Took a look at this while working HHH-8864. As you mention, counts and distinct counts aren't supported by numerous DBs. So, unless someone wants to update this to make it respect relevant methods in Dialect, it's probably best to reject it.