Hi Lukas, Thanks for the reply.
Yes, I would like to avoid the code generator to generate the Java classes corresponding to the database tables. My Scenario is I have to write very big queries which are like 200 to 400 lines queries having many with clauses. In these queries, I have to pass to some parameters also. So I am trying to evaluate JOOQ to achieve the below - Handling the SQL queries generation with some readable way. - Avoid complex string generation along with parameters - SQL Injection issues - Generate the SQL and use the spring jdbc template Regards, Mohan On Monday, 5 June 2017 06:25:12 UTC-5, Lukas Eder wrote: > > 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: > https://db-engines.com/en/ranking > > 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 > > 2017-06-02 22:35 GMT+02:00 Mohan <[email protected] <javascript:>>: > >> Hi, >> >> If I want to use JOOQ just to write complex sql queries with >> https://www.snowflake.net/ then what kind of license should be used? >> Opensource is good? >> >> Also Can I use JOOQ to write queries directly with table and columns >> names with having a pojo clases for it and read the data like jdbc way? >> >> Regards, >> Mohan >> >> -- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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.
