Ah, OK. In that case, how about this as an enhancement, as it seems almost supported already?
The sorting/limiting can be done fully in the database and it fits the concept of mapping object hierarchies to relational tables.

Alternatively, how would I query a hierarchy of objects in Hibernate as, unless I am mistaken, I can't guarantee to query a single concrete type under a mapped superclass unless it has either a supertype or a subtype (HHH-10628)?

Basically I need to be able to either:

• Return results from multiple tables with the combined result sorted by a common column (on the abstract supertype) and limited.

or

• Return ordered/limited results for each concrete type in the hierarchy individually.

Thank you!