Ugh, that's right. This unfortunately needs to be an INNER join because of how some Hibernate internals work. You can see the conversation with myself at : https://github.com/hibernate/hibernate-orm/commit/3cdc4476542424bf9a306c79fac3beb2a2580657#diff-29d4baebcef7372adcd40f9a36d81bbcR79

I expect this to be addressed in the work we are doing to rewrite the query parser, but unfortunately I don't see a way to fix it before that.