is [not] json predicate

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⊘ 3.5.7 - 3.40.0a⊘ 2008R2 - 2022⊘ 8.3 - 15⚠ 12cR1 - 21cbc⊘ 11gR1 - 11gR2⊘ 5.0 - 8.0.31⊘ 5.1 - 10.10⊘ 9.7 - 11.5.7⊘ 2.0
  1. See JSON1 extension
  2. No type constraints: is json [ value | array | object | scalar ]
  3. Also unique keys (T822)