Why is jOOQ becoming increasingly popular in the Java ecosystem?
Java and SQL are both very popular languages in enterprise software development. Yet, the only standard interface between the two is JDBC, which is agreed by many programmers to be a very awkward, stateful and verbose API. Being low-level, it covers (almost) complete access to all SQL standard and vendor-specific SQL functionality, but client code is tedious to write, string-based, and thus, error-prone.
Other alternative standards (JPA and JDO) mostly hide SQL from their clients. While they ease the pain for writing CRUD, querying may become very difficult or slow.
jOOQ is a true and increasingly popular Open Source alternative to the Java standards, where users want to embed typesafe SQL as an internal domain-specific language directly into their Java code. The Java compiler can infer a lot of SQL syntax, metamodel and data type typesafety for you via jOOQ's unique fluent API technique and row value expression typesafety.