First of all, my full apologies for taking an old thread back, but I think that this post from Frankie reflects my doubt exactly.
I've found lots of lacks in JPQL for these years (compared to the possibilities of pure SQL). In version 1.0, and also in 2.0. One of the most frustrating ones has been not being able to do conditional left outer joins, just like this thread exposes.
Fortunately, the API which I'm using (Hibernate) has a way to achieve this with the keyword WITH, which is equivalent in some way to ON in SQL, and even admits references of type many-to-one inside, using a simple dot notation.
But... Do you know if there is any plan from the creators of the JPQL standard to include a feature like this one?
Joined: Oct 01, 2007
I believe this is planned for JPA 2.1 with the ON clause.