We are looking for a way to limit the aggregation result dimensions, i.e. to select the count of something for every day, and break it down by two dimensions, then get results for all the days, but only the top x dimension pairs for every day. Is there a feature like this planned?

What would the query look like in SQL (assuming full sql support)?

I don't know of any standard sql feature like this.

You could break it down into multiple queries, one for each day. How many days are you interested in?