JSON path: filter expression ?(…)

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⊘ 3.9.1 - 3.40.0⊘ 2016 - 2022⚠ 12 - 15⚠ 19c - 21cabcd⊘ 5.7 - 8.0.31⊘ 10.2 - 10.10⊘ 11.5.4 - 11.5.7⊘ 2.0
  1. Comparisons cannot have two expressions
  2. Like_regex doesn’t accept flags
  3. No (…) is unknown
  4. Buggy: Null handling in <= and >=, negation of unknown