Hello > :VALUE part is easy, but how to implement :EQUALITY and :ORDER without > writing any SQL? > > I was looking for something like this: > > equality = jOOQ.Equality.GT > order = jOOQ.Order.ASC
Those are good ideas, but they're currently not available in the public API. I have added feature requests #1841, #1482 for this: - Adding SortField Field.sort(SortOrder) https://github.com/jOOQ/jOOQ/issues/1841 - Adding Condition Field.compare(Comparator, Field<T>) https://github.com/jOOQ/jOOQ/issues/1842 These will make it into jOOQ 2.6.0 Cheers Lukas
