Support for GROUP BY/HAVING

[tiafouroohi]

Component

GraphQL Engine

Is your proposal related to a problem?

Currently running into a situation with row group using ag-grid where a solution is needed for getting the counts of an unknown set of columns.

SELECT state, category, count(*)

WHERE state = 'COMPLETED'

GROUP BY state, category;

The view method won't work because the list of columns in the group by is dynamic based on what columns the user decides to group.

Describe the solution you'd like

Add GROUP BY/HAVING