SQL: Allow ordering of groups based on aggregates

[costin]

Due to the way composite aggs are currently implemented, one can sort only by the its keys. This is limiting as a good portion of use cases need to do just that:
GROUP BY countries ORDER BY COUNT(*)

[TimHeckel]

This would be so beneficial -- is this planned for 6.6.0? I haven't tried, but I assume it's not baked in 6.5.0 correct? I know it's not working in 6.4.1.

[alexfrancoeur]

@costin also interested, is this something we're still targeting for 6.6?

[costin]

No, there was too much work for this to make it into 6.6; it will be addressed in a future version.

[Kels]

Is there a workaround ? Canvas seems hard to use without the possibility to limit results after an order by counting