JSON path: default mode (lax)

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⚠ 3.9.1 - 3.40.0ab⚠ 2016 - 2022ab✓ 12+⚠ 19c - 21ce✓ 18c⚠ 12cR2✓ 12cR1⚠ 5.7 - 8.0.31a⚠ 10.2 - 10.10acd⚠ 11.5.0 - 11.5.7f⚠ 2.0ab
  1. No unwrap
  2. No wrap
  3. Wildcard array accessor (.[*]) doesn’t wrap
  4. SQL/JSON path syntax errors not reported
  5. Filter expression (? (…)) doesn’t unwrap
  6. SQL/JSON path syntax errors not reported (not even with ERROR ON ERROR)