json_arrayagg

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