Retrieve/Refactor table & column name

General SQL Parser is a Java/.NET library. It provides a rich set of APIs to parse, decode, analyze and rewrite SQL scripts. Supports more than 10 major database platforms.

Precisely determining and renaming every table and column in stored SQL statements is very complex with a lot of nesting and sub-queries, but we can make it hassle-free for you. If you need to rewrite SQL before execution, this feature is quite easy to use no matter the table column is in select list or in conditions of where,having or join clause.

If you also like to add or remove columns in the select list, or modify where clause, join condition and etc. Please check testScriptWriter demo shipped together with this library. This demo illustrates how to rebuild the whole SQL query from the parse tree nodes, you can change anything you need in the SQL query.

Any questions? Feel free to submit your request here.