(original) (raw)

json_table

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite20092011201320152017201920212023⊘ 3.9.1 - 3.49.0c⊘ 3.5.7 - 3.8.11⊘ 2016 - 2022d⊘ 2008R2 - 2014✓ 17+ab⊘ 9.4 - 16b⊘ 8.3 - 9.3✓ 12cR1 - 23.7a⊘ 11gR1 - 11gR2✓ 8.0.11 - 9.3.0a⊘ 5.0 - 5.7✓ 10.6 - 11.7a⊘ 5.1 - 10.5⚠ 11.5.0 - 12.1ae⊘ 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