json_arrayagg

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⊘ 3.5.7 - 3.39.0e⊘ 2008R2 - 2019d⊘ 8.3 - 14c✓ 12cR2+⊘ 11gR1 - 12cR1✓ 8.0.16+a⊘ 8.0.12 - 8.0.14a✓ 8.0.11a⊘ 5.0 - 5.7b✓ 10.5+a⊘ 5.1 - 10.4⊘ 9.7 - 11.5.7⊘ 2.0
  1. No order by clause
  2. Backported to 5.7.22
  3. Has proprietary json_agg
  4. Proprietary syntax available: FOR JSON AUTO
  5. Proprietary syntax available: json_group_array (requires the JSON1 extension)