Wrong error highlighting for JSON_BUILD_OBJECT : DBE-15391
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
Constructing GeoJSON in PostgreSQL | Simon Willison's TILs
sql - Using json_build_object - Stack Overflow
How to Use jsonb_build_object() Function in PostgreSQL - CommandPrompt Inc.
simplifier la création du fichier Json par PHP par PaulAkakpo - page 1 - OpenClassrooms
query - select json b field of array postgresql of an array field in json - Database Administrators Stack Exchange
PostgreSQL JSON 函数功能使用- 文章详情
Importing and serving millions of records - Speaker Deck
PostgreSQL slow with million row aggregation (how to debug)
PostgreSQL JSON Functions and Operators | Hevo
json - PSQL Dynamic Key value for json_agg - Stack Overflow
What I Learned at Work this Week: More SQL Syntax | by Mike Diaz | Medium
Returning related rows in a single SQL query using JSON | Simon Willison's TILs
postgresql - Merge jsonb rows of a column into json build object in postgres - Stack Overflow
How Does the JSON_BUILD_OBJECT() Function Work in PostgreSQL - CommandPrompt Inc.
Custom SQL function (json_agg & json_build_object) - Drizzle Team