Sometime ago JOOQ introduced Multiset operator, which is really nice way to deal with associations - https://blog.jooq.org/jooq-3-15s-new-multiset-operator-will-change-how-you-think-about-sql. In short, it allows to fetch associated data with main entity (as nested collections) in one request and solves problem of de-duplication with normal joins.

Any chance we will get something similar in this great library?