json_query

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