Skip to content
jOOQ is the best way to write SQL in Java
Branch: master
Clone or download
Type Name Latest commit message Commit time
Failed to load latest commit information.
jOOQ-checker [#5899] jOOQ-checker should provide both checker-framework and ErrorP… Feb 14, 2019
jOOQ-examples [#7809] Generate overridden Table.fieldsRow() method in generated tables Mar 5, 2019
jOOQ-manual/src/main/resources/org/jooq/web [#8423] Typo in manual example code for dynamic SQL Mar 15, 2019
jOOQ-meta-extensions [#8325] Add a special comment syntax to the Parser and DDLDatabase th… Feb 14, 2019
jOOQ-meta [#8407] Add code generation configuration flag to set Connection.setA… Mar 14, 2019
jOOQ-release Release 3.11.10 Mar 14, 2019
jOOQ-scala_2.12 [#7856] Upgrade maven-scala-plugin to scala-maven-plugin Sep 12, 2018
jOOQ-xtend/src/main/xtend/org/jooq/xtend [#5196] Add support for Amazon Aurora MySQL Edition Apr 26, 2018
jOOQ [#8424] Better VALUES() emulation in Informix using TABLE(MULTISET) Mar 18, 2019
.gitignore whitespace change Jan 29, 2015
.travis.yml [#7649] Jul 10, 2018
LICENSE [#5754] Remove copyright (and dates) from file headers Jan 2, 2017

jOOQ's reason for being - compared to JPA

Java and SQL have come a long way. SQL is an "ancient", yet established and well-understood technology. Java is a legacy too, although its platform JVM allows for many new and contemporary languages built on top of it. Yet, after all these years, libraries dealing with the interface between SQL and Java have come and gone, leaving JPA to be a standard that is accepted only with doubts, short of any surviving options.

So far, there had been only few database abstraction frameworks or libraries, that truly respected SQL as a first class citizen among languages. Most frameworks, including the industry standards JPA, EJB, Hibernate, JDO, Criteria Query, and many others try to hide SQL itself, minimising its scope to things called JPQL, HQL, JDOQL and various other inferior query languages

jOOQ has come to fill this gap.

jOOQ's reason of being - compared to LINQ

Other platforms incorporate ideas such as LINQ (with LINQ-to-SQL), or Scala's SLICK, or also Java's QueryDSL to better integrate querying as a concept into their respective language. By querying, they understand querying of arbitrary targets, such as SQL, XML, Collections and other heterogeneous data stores. jOOQ claims that this is going the wrong way too.

In more advanced querying use-cases (more than simple CRUD and the occasional JOIN), people will want to profit from the expressivity of SQL. Due to the relational nature of SQL, this is quite different from what object-oriented and partially functional languages such as C#, Scala, or Java can offer.

It is very hard to formally express and validate joins and the ad-hoc table expression types they create. It gets even harder when you want support for more advanced table expressions, such as pivot tables, unnested cursors, or just arbitrary projections from derived tables. With a very strong object-oriented typing model, these features will probably stay out of scope.

In essence, the decision of creating an API that looks like SQL or one that looks like C#, Scala, Java is a definite decision in favour of one or the other platform. While it will be easier to evolve SLICK in similar ways as LINQ (or QueryDSL in the Java world), SQL feature scope that clearly communicates its underlying intent will be very hard to add, later on (e.g. how would you model Oracle's partitioned outer join syntax? How would you model ANSI/ISO SQL:1999 grouping sets? How can you support scalar subquery caching? etc...).

jOOQ has come to fill this gap.

jOOQ is different

SQL was never meant to be abstracted. To be confined in the narrow boundaries of heavy mappers, hiding the beauty and simplicity of relational data. SQL was never meant to be object-oriented. SQL was never meant to be anything other than... SQL!

For more details please visit

Follow jOOQ on Twitter and the jOOQ blog.

You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.