• https://stackoverflow.com/questions/72312526/json-arrays-of-objects-postgresql-table-format
• https://www.tigerdata.com/learn/how-to-query-jsonb-in-postgresql

• editor online json

• https://www.crunchydata.com/blog/easily-convert-json-into-columns-and-rows-with-json_table

• https://gitlab.syncad.com/hive/pgsql-http/-/blob/master/sql/http.sql

• https://www.postgresql.org/docs/9.5/functions-json.html

select * from 
json_to_recordset(
  '{"a":{"b":[{"f1":2,"f2":4},{"f1":3,"f2":6}]}}'::json->'a'->'b' --inner table b 
) 
as x("f1" int, "f2" int); --fields from table b

SELECT '{"sensor_id": "1234", "reading": {"temperature": 22.5, "unit": "C"}}'::jsonb -> 'reading' ->> 'unit' AS sensor_reading;