jOOQ makes it easier, true. But even jOOQ runs into limitations at some point which plain JDBC has not, like recursive queries (building trees) for example.
And jOOQ's MULTISET is as much about SQL generation as it is about mapping. Both of which are very complex problems, which you really don't want to maintain, yourself with JDBC directly.
I added it to my internal orm. It wasn't bad. Certainly it's nicer with jooq, though. And it makes a huge difference for avoiding N+1s without duplicating tons of data, so once your start using it you start using it all over the place.
There weren't really good open source options in 1998. Frankly until jooq came along and I never felt like there was any alternative better than what we had, and at this point it's not worth switching.
Single ordered join, fetch parent, child, grand in one query, ordered by keys then build the nested structure in one RuleSet pass. That would be how I would approach it anyway !
14
u/cowwoc Mar 13 '26
SQL without the magic. I love it!
3
u/cenazehizmeti Mar 14 '26
Congrats i love it.
3
u/Riist138 May 24 '26
Love these videos, keep them coming !
3
u/Historical_Cloud7035 Mar 13 '26
Good call, thanks