Anghel Leonard 
jOOQ Masterclass [EPUB ebook] 
A practical guide for Java developers to write SQL queries for complex database interactions

j OOQ is an excellent query builder framework that allows you to emulate database-specific SQL statements using a fluent, intuitive, and flexible DSL API. j OOQ is fully capable of handling the most complex SQL in more than 30 different database dialects.
j OOQ Masterclass covers j OOQ from beginner to expert level using examples (for My SQL, Postgre SQL, SQL Server, and Oracle) that show you how j OOQ is a mature and complete solution for implementing the persistence layer. You’ll learn how to use j OOQ in Spring Boot apps as a replacement for Spring Template and Spring Data JPA. Next, you’ll unleash j OOQ type-safe queries and CRUD operations via j OOQ’s records, converters, bindings, types, mappers, multi-tenancy, logging, and testing. Later, the book shows you how to use j OOQ to exploit powerful SQL features such as UDTs, embeddable types, embedded keys, and more. As you progress, you’ll cover trending topics such as identifiers, batching, lazy loading, pagination, and HTTP long conversations. For implementation purposes, the j OOQ examples explained in this book are written in the Spring Boot context for Maven/Gradle against My SQL, Postgres, SQL Server, and Oracle.
By the end of this book, you’ll be a j OOQ power user capable of integrating j OOQ in the most modern and sophisticated apps including enterprise apps, microservices, and so on.