json_object…( 'a' , 42)
BigQuery
Db2 (LUW)
DuckDB
H2
MariaDB
MySQL
Oracle DB
PostgreSQL
SQL Server
SQLite
2013
2015
2017
2019
2021
2023
3.9.1 - 3.51.0
a
12cR2 - 23.26.0
8.0.11 - 9.5.0
a
5.7
a
10.6 - 12.0.2
a
10.2 - 10.5
a
1.0.0 - 1.4.0
a
2.0
a
Only for
json_object