Many people compare jOOQ with MyBatis. Both are seen as popular alternatives to Java's persistence standard JPA, as both are much more SQL-focused than JPA itself.
In this blog post, I have compared using the two tools for SQL templating. SQL templating is a popular technique when you want to cleanly externalise your SQL statements from your Java code in order to be able to tweak those statements for performance improvements at runtime.
When Java and SQL work together, great software can evolve. That's why we have created jOOQ. Follow me on blog.jooq.org