Re: Subqueries in JPQL

[Jeremy Bauer]

Another option to consider is to create a view in the database which
looks similar to your original SQL and then map that view to an entity
or composition of entities.  If your object model is fixed that may
not be an option, though.

-Jeremy