Hi Deepankar, Thank you for your message. Our parser doesn't support user-defined table valued functions yet, see: https://github.com/jOOQ/jOOQ/issues/16200
But you can implement your own ParseListener to intercept the parsing of Table expression and implement your own behaviour easily: https://www.jooq.org/doc/latest/manual/sql-building/sql-parser/sql-parser-listener/ I hope this helps, Lukas On Mon, Mar 18, 2024 at 1:53 PM deepankar gupta < [email protected]> wrote: > Hi Lukas, > > We have a custom sql having table valued function in it which we are > trying to parse in jooq using parseSelect ` > context.parser().parseSelect(customViewSQL);`. > > When we have custom sql like this: > *SELECT * FROM Table_valued_function ('Al%');* > Error: It is not able recognize Table valued function > > When we have custom sql like this *SELECT Table_valued_function ('Al%');* > It is working fine but not in desired format. We are expecting it in table > and it is coming as tuple. > > > Regards > Deepankar Gupta > > -- > 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/38608a57-757d-4882-ac85-eae8edf82bcdn%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/38608a57-757d-4882-ac85-eae8edf82bcdn%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/CAB4ELO7NYqv-BYXgnWrEbOJEtXCUh0gPHAOs2XrQt3T_ty_BYg%40mail.gmail.com.
