json_array

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⚠ 3.9.1 - 3.40.0bc⊘ 3.5.7 - 3.8.11a⚠ 2022c⊘ 2008R2 - 2019⊘ 8.3 - 15⚠ 12cR2 - 21cc⊘ 11gR1 - 12cR1⚠ 5.7 - 8.0.31bc⊘ 5.0 - 5.6⚠ 10.2 - 10.10bc⊘ 5.1 - 10.1⚠ 11.5.6 - 11.5.7c⊘ 9.7 - 11.5.5⊘ 2.0
  1. See JSON1 extension
  2. Defaults to absent on null
  3. No construction by query: json_array(select …)