groupby should accept functions, e.g. datetrunc

[neilotoole]

There's currently no way to express this SQL query as SLQ.

select date_trunc('month', payment_date) as onthisdate, count(payment_id) as count from payment
group by date_trunc('month', payment_date)

That is to say, groupby should accept functions, e.g.

sq '.payment | date_trunc('month', .payment_date):onthisdate, count(.payment_id):count | groupby(date_trunc('month', .payment_date))

[neilotoole]

This is implemented. See query guide.