I was wondering how one would execute this query with generated classes from Jooq?
This is the raw SQL I would like to implement. select provider_3pas_mapping_id, max(value) filter (where api_setting_parameter_id = 46) as username, max(value) filter (where api_setting_parameter_id = 47) as passwd from integration.api_setting_parameter_value as vjoin integration.api_setting_parameter as p on v.api_setting_parameter_id = p.id and data_source = 'Foobar' group by 1; The only note I found related to this is from an old 2015 blog. Is this supported by jooq? or does it have to be native SQL ? -- Thank you Samir Faci https://keybase.io/csgeek -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
