JSON path: member accessor .… (original) (raw)

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite201320152017201920212023⚠ 3.39.0 - 3.49.0b⚠ 3.9.1 - 3.38.0ab⊘ 3.5.7 - 3.8.11⚠ 2016 - 2022a⊘ 2008R2 - 2014✓ 12 - 17⊘ 9.4 - 11✓ 12cR2 - 23.7⚠ 12cR1⊘ 11gR1 - 11gR2✓ 8.0.11 - 9.3.0⚠ 5.7⊘ 5.0 - 5.6✓ 10.2 - 11.7⊘ 5.1 - 10.1⚠ 11.5.0 - 12.1c⊘ 9.7 - 11.1⚠ 2.0a

1. No wildcard (.*)
2. Quoted keys don’t support backslash escapes (\") nor the empty key ($."")
3. No quoted key names (."…")