I have implemented the Visitors of JSqlparser to parse SQL queries. The code is working absolutely fine. I am not sure how to do unit testing for those visitors. For example I have the following sql statement: Select a.a1, a.a2 from foo as a To parse it I have implemented StatementVisitor interface
I am looking for an open source API in Java to parse an SQL / HQL query so that it gives me the column names and the table names used in it. I tried using JSQLParser which gives me the table names used in the query. But I don't see a support for getting the column names used in the query. Is there
I have started to use JSqlParser, i can parse a Where clause but i don't manage to go further with it. JSqlParser github link Indeed, i have tried to Override visit methods but don't understand how to reach my goal. Let's say i have: (a=1 AND (b=2 OR (c=3 AND d=4))) OR e=2 as input and i would like