3 ms·
I don't think there is a good way to return nested JSON using SQL, which this example does.
by ash 5y ago
I don't think there is a good way to return nested JSON using SQL, which this example does.
- valenterry 5y agoI think postgres' json syntax in the latest version isn't too bad for these things.
- ash 5y agoIt would be nice to see how this query could look in Postgres.
- mritchie712 5y agoPostgres has excellent syntax for dealing with JSON https://www.postgresql.org/docs/14/functions-json.html https://www.postgresql.org/docs/14/functions-json.html