Simon Willison on X: "The same trick works in PostgreSQL, using the json_agg() and json_build_object() functions: https://t.co/Kl0mPgpN76 https://t.co/FjP5svSTu8" / X
sql - Using json_build_object - Stack Overflow
The JSON Playground in SingleStoreDB
postgresql - PosgresSQL - sql to generate Json from multiple tables - Stack Overflow
Recursive JSON generation in PostgreSQL - Stack Overflow
support json_build_object · Issue #182 · adelsz/pgtyped · GitHub
json - PSQL Dynamic Key value for json_agg - Stack Overflow