I would like to be able to group by one field, then another instead of only grouping by a combination of fields.
For example if I have products that can be in multiple categories, I want to write a query that shows each product only once (e.g. group by product id with limit 1, don't particularly care which category gets used), but then group by category after