My understanding is that Hibernate does not support anonymous views (sometimes referred to as derived tables) in the from clause. For instance:


I understand that I can use native SQL, but if possible I would really prefer to use HQL. I prefer the syntax and this is all part of an adhoc query engine that builds HQL queries and submits them.

For a variety of reasons, I can't put the subquery in a <subselect> definition.

If Hibernate does support this, please let me know. If not, is it worth creating a JIRA issue, or will it be rejected out of hand.

Hibernate version: 3.1.2

Name and version of the database you are using:Oracle9i