Hi Lukas, Your example works only with simple select from one table, I presume. I am rarely dealing with such queries, so it won't be a solution for me.
By the way, even more helpful feature would be the ability to declare type of query result, isolating type safety issues in a selected place. I construct a complex query returning a known set of columns and I would have liked to declare a record class for that result. Currently I have not found how to make a JOOQ query which would return me records of that type, it seems only simple queries agains a single predefined table can be strongly typed. It would be nice to define a record class describing a result set and tell JOOQ that a query is mapped to that record class and get strongly typed query. Any possible schema mismatch if any whould then be contained in a single place. Cheers, Vasily
