Automatically disable order by clause for count() with where/named queries

It's fairly common with pagination to want to use the same query to both return the results and the total count. It's also convenient to include some sorting into Where or Named queries. However, if you call count() on them while they have sorting options, the query will fail.

It would be great if Grails automatically ignored any sort options when calling count() or equivalent.