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