2021

Querying Nested JSON in PostgreSQL

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...

Back to Top ↑

2020

Back to Top ↑