7.6.3. Returning Values from SELECT Queries
jOOQ offers several methods for fetching data from SQL queries. We are not covering all of them here but you can find more details about them in the Fetching section of the jOOQ documentation.
For our example, we will return the data to a map list (the fetchMaps
method) which is handy to use for serializing a result for JSON.