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