Re: Access SELECT and WHERE Clause column names in SQL Query
Thank you Michael.
I tried SqlVisitor only earlier but was not able to make that work. Got it
now and able to fetch required details from the query.
On Tue, Oct 30, 2018 at 7:00 PM Michael Mior <mmior@xxxxxxxxxx> wrote:
> What have you tried? You should be able to build a SqlParser and call the
> parseQuery method. With the resulting SqlNode, you may want to try
> implementing the SqlVisitor interface to get the data you need.
> Michael Mior
> Le mar. 30 oct. 2018 à 02:02, Shashwat Kumar <shashwatkmr.001@xxxxxxxxx> a
> écrit :
> > Hi,
> > My backend gets the SQL query from the user. I want to modify SQL
> > before executing it. How can I get the SELECT column names and WHERE
> > names from the SQL query.
> > I know that probably SqlParser is to be used but I am not able to make it
> > work. Please advise.
> > --
> > Regards
> > Shashwat Kumar