I like this as a general rule, but I almost always have more refined validation at the app layer -- particularly when using jsonb. Tool of choice is ecto which

I like this as a general rule, but I almost always have more refined validation at the app layer -- particularly when using jsonb. Tool of choice is ecto which has excellent support for maintaining jsonb structure.