Support standard ARRAY_AGG

SQL defines array_agg as a function that returns an array given a value expression in Section 10.9. Hive has something similar called collect_list. The SQL standard array_agg additionally allows sorting by a value expression. It would be good to move to the standard and as a first step it might be worthwhile to have array_agg as an alias and then to add support for sort specifications.