Using JOOQ's orderBy() with Trunc()-ed Fields from DatePart

Dynamic SQL with jOOQ: A Functional Programming Approach to Query Modifiers

Eliminating Code Duplication in PostgreSQL with the EXCLUDED Clause and jOOQ's UpdatableRecord

Creating Subqueries Using the WITH Clause with jOOQ: A Simpler Approach