Is it possible to add/render the "SQL_CALC_FOUND_ROWS" which is necessary for the by MySql FOUND_ROWS() function to the Jooq-Select Statement to retrieve the total of the result set not limit by the limit statement ?
MySql Reference: FOUND_ROWS()<http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_found-rows> My workaround would be to add "SQL_CALC_FOUND_ROWS" as a Jooq-Field but jooq will render the comma ',' after the "SQL_CALC_FOUND_ROWS" which has to be removed after rendering. Not that nice workaround which I'd like to avoid. Thanks.
