I mostly blame it on Linq but you are right it mostly because bad documentation on both the provider and the general stuff on how Linq works.

Yes Java does not have an alternative for Linq and jooq is a poor knock-off compared to this but then again: I do not care much for JPA/Hibernate.