(original) (raw)

json_array

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite201320152017201920212023⚠ 3.49.0c⚠ 3.9.1 - 3.47.0ab⊘ 3.5.7 - 3.8.11⚠ 2022b⊘ 2008R2 - 2019✓ 16 - 17⊘ 8.3 - 15✓ 23.0 - 23.7b⚠ 12cR2 - 21cb⊘ 11gR1 - 12cR1⚠ 5.7 - 9.3.0ab⊘ 5.0 - 5.6⚠ 10.2 - 11.7ab⊘ 5.1 - 10.1⚠ 11.5.6 - 12.1b⊘ 9.7 - 11.1⚠ 2.0ab⊘ 2.0

1. Defaults to absent on null
2. No construction by query: json_array(select …)
3. Requires the -DSQLITE_ENABLE_JSON1 compile-time option prior to SQLite 3.38.0