Chapter 5: Tackling Different Kinds of SELECT, INSERT, UPDATE, DELETE, and MERGE

A common scenario for jOOQ beginners originates from having a plain valid SQL that should be expressed via the jOOQ DSL API. While the jOOQ DSL API is extremely intuitive and easy to learn, the lack of practice may still lead to scenarios where we simply cannot find or intuit the proper DSL methods that should be chained to express a certain SQL.

This chapter addresses this kind of issue via a comprehensive collection of popular queries, which gives you the chance to practice jOOQ DSL syntax based on the Java-based schema. More precisely, our aim is to express, in jOOQ DSL syntax, a carefully harvested list of SELECT, INSERT, UPDATE, DELETE, and MERGE statements that are used in our day-to-day job.

This way, by the end of this chapter, you should have funneled a significant number of SQLs through the jOOQ DSL syntax and tried them out against MySQL, PostgreSQL, SQL Server, and Oracle databases in...