Motivation
When creating complex hierarchical queries it can be very useful to let the database return JSON instead of rows.
Proposed Solutions
Most databases support JSON aggregate functions like json_agg and row_to_json.
Additional Information
https://www.postgresql.org/docs/current/functions-json.html
https://www.sqlite.org/json1.html
Motivation
When creating complex hierarchical queries it can be very useful to let the database return JSON instead of rows.
Proposed Solutions
Most databases support JSON aggregate functions like
json_aggandrow_to_json.Additional Information
https://www.postgresql.org/docs/current/functions-json.html
https://www.sqlite.org/json1.html