Probably for a query that your application runs occasionally, in-memory processing of JSON data might still be an option. In general, though, querying through JSON-dedicated functions and letting SQL ...

Haas implemented a core JSON type that does basic validation. Dunstan expanded on that by implementing query_to_json , record_to_json , and array_to_json functions that can be used in SQL queries ...

Probably for a query that your application runs occasionally, in-memory processing of JSON data might still be an option. In general, though, querying through JSON-dedicated functions and letting SQL ...