json_object

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⊘ 3.5.7 - 3.40.0a⊘ 2008R2 - 2022⊘ 8.3 - 15✓ 21c+c✓ 12cR2 - 19cbc⊘ 11gR1 - 12cR1⊘ 5.0 - 8.0.31⊘ 5.1 - 10.10✓ 11.5.0+b⊘ 9.7 - 11.1⊘ 2.0
  1. See JSON1 extension
  2. No colon syntax (T814)
  3. No key uniqueness constraint (T830): [with|without] unique [keys]