Hooking jOOQ results (Result) and records (Record)

In the previous chapters, we've mapped the JDBC result set of our queries to POJOs via the jOOQ fetchInto() method. But, in jOOQ, between the JDBC result set and a well-known List<POJO> (or other data structure such as an array, map, and set), there is another fundamental layer referenced as Result<Record> represented from the following two interfaces:

• org.jooq.Record: When we trigger a SELECT query, we get back a result set that contains a list of columns and the corresponding list of values. Typically, we refer to the content of the result set as records. jOOQ maps each such record to its Record interface. Think of Record as the jOOQ internal representation of records.
• org.jooq.Result: The jOOQ Result interface is a java.util.List of org.jooq.Record. In other words, jOOQ maps each record of the result set to a Record and collects this record in Result. Once Result<Record> is complete (the whole...