Querying Nested JSON in PostgreSQL March 20, 2021 2 minute read The core of this technique can be distilled into this query. SELECT * FROM orders, LATERAL json_array_elements(orders.raw_payload -> 'line_items') js...