Without sql's GROUP BY is heavily limited.
I suggest the following scheme QueryContext will emit a group by clause when at least one aggregated column was selected.
In this case all non aggregated columns will be included in group by.
This will probably not match restrictions set by databases but I think it should be a valid MVP.
Without sql's
GROUP BYis heavily limited.I suggest the following scheme
QueryContextwill emit a group by clause when at least one aggregated column was selected.In this case all non aggregated columns will be included in group by.
This will probably not match restrictions set by databases but I think it should be a valid MVP.