EdgeDB is built on postgresql and has excellent JSON integration.
https://edgedb.com/docs/datamodel/scalars/json#type::std::js...
Re:We Can Do Better Than SQL
by KingOfCoders on Tuesday August 11, 2020 @10:22AM
(#24120523)
I wish instead of
SELECT to_json('{"hello": "world"}');
it would be
SELECT {"hello": "world"};
Having worked with MongoDB for 5+ years now back to PostgreSQL, I do like SQL so much more than a custom query language. I would wish JSON would be better integrated in SQL, it kind of feels like an addon not the core. Otherwise SQL is a fine language.
Also I can leverage 20y of SQL.