Summary
This chapter is a comprehensive resource for examples of expressing popular SELECT
, INSERT
, UPDATE
, DELETE
, and MERGE
statements in the jOOQ DSL syntax relying on the Java-based schema.
For brevity, we couldn't list all the examples here, but I strongly recommend you take each application and practice the examples against your favorite database. The main goal is to get you familiar with the jOOQ syntax and to become capable of expressing any plain SQL via the jOOQ API in a productive amount of time.
In the next chapter, we continue this adventure with a very exciting topic: expressing JOIN
in jOOQ.