JSON path: filter expression
?(…)
BigQuery
Db2 (LUW)
MariaDB
MySQL
Oracle DB
PostgreSQL
SQL Server
SQLite
2013
2015
2017
2019
2021
⊘ 3.9.1 - 3.43.0
⊘ 2016 - 2022
⚠ 12 - 16
⚠ 19c - 21c
a
b
c
d
⚠ 12cR2 - 18c
⊘ 5.7 - 8.0.34
⊘ 10.2 - 10.11
⊘ 11.5.4 - 11.5.8
⊘ 2.0
Comparisons cannot have two expressions
Like_regex
doesn’t accept flags
No
(…) is unknown
Buggy: Null handling in
<=
and
>=
, negation of unknown