JSON path: filter expression
?(…)
BigQuery
Db2 (LUW)
MariaDB
MySQL
Oracle DB
PostgreSQL
SQL Server
SQLite
2015
2017
2019
2021
2023
⊘ 3.9.1 - 3.50.0
⊘ 2016 - 2022
⚠ 12 - 17
⚠ 23.0 - 23.9
d
⚠ 19c - 21c
a
b
c
d
⚠ 12cR2 - 18c
⊘ 11gR1 - 12cR1
⊘ 5.7 - 9.4.0
⊘ 10.2 - 12.0.2
⊘ 9.7 - 12.1.2
⊘ 2.0
Comparisons cannot have two expressions
Like_regex
doesn’t accept flags
No
(…) is unknown
Buggy: Null handling in
<=
and
>=
, negation of unknown