Change structure of the content of a JSON field in Postgres
I have a table that contains a JSON column
How to return nested json from three joined tables in a postgresql function?
I’m not super experienced with SQL, but I’m trying to build a postgresql function that joins three tables and returns an array of nested json data.