Hello, Jooq generated record classes make single table based operation very easy. However, while I have noticed methods for navigating through relations I could not find ways to avoid the well-known n+1 issue other than hand writing JOINS, IN queries or SubSelects when manipulating collections of record. While it is clearly not an easily solved issue, I am wondering if there has already been some investigation about possible ways to enable preloading of relations in some way, for example by the mean of dedicated collection classes?
Best
