[zie]

In PostgreSQL, you can just select against JSON and query away to your hearts content. They have JSON data types and functions to work on it.

[masklinn]

That’s pretty much just jq though, you have bespoke json querying capabilities in sql but you’re not sql-querying your json.

At least not before postgres 17, in the latter json_table does provide this capability.

[zie]

Thankfully PG17 is released and ready for production querying needs!