[ecuaflo]

I think SQLite columns for SQLite would be superior to SQLite’s JSON columns whose operators are a whole ‘nother query language you need to learn and seem comparatively limited.

[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.

[maCDzP]

I spent some time learning those queries for a project and when I grokked it they where very handy.

[xyc]

With Claude you barely had to learn the language this days as you just need to prompt, but SQLite column is an interesting idea.

[ray_v]

wouldn't that just be a foreign key to another table or, a list of keys or am i missing something?

[ecuaflo]

I think it’s useful when you only need to query one way and can then avoid a join each time/extra schema complexity of a join table.