add group by in other queries?

[aaronleopold]

This should be handled in the mikro branch, as the ORM has efficient tools for this.