json_query

BigQueryDb2 (LUW)DuckDBMariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite20092011201320152017201920212023⊘ 3.51.0c⊘ 3.5.7 - 3.50.0⚠ 2016 - 2025a⊘ 2008R2 - 2014⚠ 17 - 18a⊘ 8.3 - 16✓ 23.26.0+b✓ 21c - 23.9a⚠ 12cR1 - 19ca⊘ 11gR1 - 11gR2⊘ 5.0 - 9.5.0⚠ 10.2 - 12.0.2a⊘ 5.1 - 10.1⊘ 1.0.0 - 1.4.0⚠ 11.5.0 - 12.1.2a⊘ 9.7 - 11.1⊘ 2.0
  1. No quotes behavior: [ keep | omit ] quotes
  2. with unconditional wrapper seems to be buggy
  3. Requires the -DSQLITE_ENABLE_JSON1 compile-time option prior to SQLite 3.38.0