Comment by james_marks

Agreed, the JSON search queries in Postgres are esoteric, to say the least.

But after spending some time with a mixed-schema table at even modest scale, I’m wondering how often a better design could have cut the whole problem off.