Hi Mohan,
Thank you very much for your enquiry, and for your interest in using jOOQ with Snowflake.
Currently, we're not officially supporting the Snowflake database and it doesn't look like this will change any time soon, as we focus mostly on databases with significant market traction, e.g. the ones on top of this list:
Nonetheless, in the past, users have been successful in using the jOOQ Open Source Edition with unsupported databases, depending on the complexity of the queries written. Some of the more SQL standard compliant dialects are PostgreSQL and HSQLDB.
Would you mind explaining your idea of using jOOQ with POJO classes a little bit more? Do you mean, you'd like to avoid using the code generator?
Best Regards,
Lukas