We have a model with lots of foreign keys (FK).
It would be nice to be able to write a query like this:
.where(user.orgUnit.location.language.isoCode.equal( 'en' ) )
jOOQ should then generate the necessary join in the SQL dialect for the
database. One important feature would be that joins are reused:
.where(user.orgUnit.location.language.isoCode.equal( 'en' ) )
.and( user.orgUnit.location.language.validTo.isNull()
or user.orgUnit.location.language.validTo.greaterThan(now()) )
Is that possible?
Regards,
A. Digulla
