I found the following section in the Hibernate documentation:

" You may supply extra join conditions using the HQL with keyword.

from Cat as cat
left join cat.kittens as kitten
with kitten.bodyWeight > 10.0 "

If I try restricting a HQL left join like this in NHibernate I get an error "unexpected token: with [...]".

Are there plans to add this keyword to NHibernate's HQL or is there a way to accomplish the same result without the "with" keyword?

(I don't want to restrict the joined tables, but join with a subset of the rows of the second table.)