How to convert JSON (org.jooq.JSON) to Java Object (POJO)
If you're not too opinionated on how the JSON should be mapped to your POJOs, it should suffice to place either Gson or Jackson on your classpath, and jOOQ will pick that up and map JSON to your POJOs automatically, see this section of the manual about the ConverterProvider
.
E.g. this should work out of the box:
List<EmployeeDetails> list =
ctx.selectFrom(EMPLOYEE_DETAILS)
.fetchInto(EmployeeDetails.class);