Thank you Christian, I ended up doing something like this forcing me to define custom dialects even for databases which supports multiple tuples distinct count.

Frankly I would consider this a bug, since a core Hibernate dialect shouldn't generate invalid syntax.