Summary
I hope you enjoyed this short but comprehensive chapter about jOOQ keys. The examples from this chapter covered popular aspects of dealing with different kinds of keys, from unique/primary keys to jOOQ-embedded and synthetic keys. I really hope that you don't stop at these examples and get curious to deep dive into these amazing jOOQ features – for instance, an interesting topic that deserves your attention is read-only columns: https://www.jooq.org/doc/dev/manual/sql-building/column-expressions/readonly-columns/.
In the next chapter, we will tackle pagination and dynamic queries.