Hi Walid, Thanks a lot for your message. We currently do not have an SPI for custom syntax elements in the parser yet, but it would be very interesting to create one. See: https://github.com/jOOQ/jOOQ/issues/10243
On the other hand, we can add additional functionality for you very quickly, as support for individual functions like add_months or last_day is not that much work. Ideally, you could provide us with a list of what's important to you in the short run (here or on a different support channel), and I'll be very happy to prioritise this accordingly. I also take from your previous messages on twitter or github, that you're still evaluating jOOQ? We can provide you with a free extended trial license so you can download the latest 3.15.0-SNAPSHOT versions and work with what's already implemented. 3.15 has already seen a lot of improvements, and will see even more until we release. Besides, the extended trial includes the source code, so you can assess how working with jOOQ will be once you make a purchasing decision (e.g. you'll be able to apply your own modifications, so you don't have to wait for new releases). If you're interested, please contact [email protected] for an extended trial. Best Regards, Lukas On Wed, Feb 24, 2021 at 10:30 AM Walid CHAIB <[email protected]> wrote: > Hi Guys, > > Thanks for this great tool. > > I am working on migrating our project from oracle to postgresql 12 with > jdbc and prepared statements, we are facing problems with date functions > like add_months , last_day that don't exist in postgresql and jooq unable > to convert it, i am wondering if there's a specific settings that i should > do, sysdate also can not be converted. > > Thanks in advance > > -- > 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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/25fd2664-9d69-4c81-8c53-c53a0ad3a34fn%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/25fd2664-9d69-4c81-8c53-c53a0ad3a34fn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO5KqRO4G22C6s5pbXQhwk5%2B7cgLoCMGdGYftAszq9ut2w%40mail.gmail.com.
