DZone
Over the past 13 years, jOOQ has accrued quite a few internal features, which you, the user, are not exposed to. One very interesting feature is the capability for any arbitrary jOOQ expression tree element to push a SQL fragment up to a higher level.
How does it work?
Source: DZone