json_table

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite20092011201320152017201920212023⊘ 3.9.1 - 3.50.0c⊘ 3.5.7 - 3.8.11⊘ 2016 - 2022d⊘ 2008R2 - 2014✓ 17+ab⊘ 9.4 - 16b⊘ 8.3 - 9.3✓ 12cR1 - 23.9a⊘ 11gR1 - 11gR2✓ 8.0.11 - 9.4.0a⊘ 5.0 - 5.7✓ 10.6 - 12.0.2a⊘ 5.1 - 10.5⚠ 11.5.0 - 12.1.2ae⊘ 9.7 - 11.1⊘ 2.0f⊘ 2.0
  1. Without plan clause
  2. Alternative: jsonb_to_recordset
  3. Alternative: json_each and json_extract
  4. Alternative: openjson
  5. Requires error on error and a strict JSON/Path for the main expression
  6. Alternative: json_query_array, unnest and json_value