>> How would you generically go about this for HSQLDB (without creating a >> UDF, of course)? > > Very good point - I was just going to resort to creating a UDF to call out > to Apache Commons DigestUtils ......
Well, I found this answer by Fred Toussi, the HSQLDB developer, here: http://stackoverflow.com/a/10777312/521799 Of course, such a solution is not viable for jOOQ's core. So if you want this to work for HSQLDB as well, you'll have to provide your own abstraction. A good way to do this is by implementing a CustomField: http://www.jooq.org/doc/2.6/manual/sql-building/queryparts/custom-queryparts/ You then have full control over its SQL rendering and variable binding, depending on the context's SQLDialect.
