Array

ARRAY() Aggregator

This aggregator is used to aggregate all values into the array.

Syntax:

    ARRAY([DISTINCT] expression)

    var res = alasql('SELECT userId, FIRST(userName) AS userName, \
          ARRAY({category:category,[count]:[count]}) AS purchases, \
          SUM([count]) AS totalCount FROM ? GROUP BY userId, userName',[data]);

See example at jsFiddle