sql: add support for GROUP BY

[petermattis]

We'll need to add a groupNode similar to sortNode. There will likely be similarities to ORDER BY in terms of handling grouping on arbitrary expressions.

See also #2043 as aggregate functions are tied together with GROUP BY.

[dt]

#3494 added GROUP BY support using arbitrary expressions (though grouping by an existing column still pending, see #3549 )