Hi Lukas, Does jooq parser support other than user-defined table valued functions like functions which has return type as text or boolean?
Regards Deepankar Gupta On Monday, March 18, 2024 at 6:31:23 PM UTC+5:30 [email protected] wrote: > 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/7b9f6ebc-2efc-4b8f-9acc-f5b6b426e116n%40googlegroups.com.
