JSON_TABLE — Shredding JSON into Relational Rows

JSON_TABLE is PostgreSQL 18's implementation of the SQL/JSON standard — it transforms JSON arrays and nested structures into regular relational rows and columns, eliminating the need for verbose json_array_elements + lateral join patterns.