parse, decode, analyze and rewrite

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.

column impact analysis

In a data warehouse environment, Scan stored procedures used in an ETL progress and collecting data lineage used in column impact analysis.

fetch table column

Scan, analyze SQL scripts and stored procedures to find relationship between table and column in various clauses like where, join condition and etc.

Refactor table & column

Precisely determining and renaming every table and column in stored SQL statements with a lot of nesting and sub-queries, modify select list, where and join condition before execution.

Rid SQL injections

Avoid being vulnerable to SQL injection in your ASP.NET or Java application, by automatically detecting malicious SQL segment with our ready-to-use library

Query parse tree in XML

Parsing SQL is a notoriously difficult task, but we are here to help. You will be provided with a SQL query parse tree in XML output that will allow you to further process SQL scripts.

SQL Join Converter

Rewrite Oracle and SQL Server proprietary joins to ANSI SQL compliant joins, automatically convert legacy joins with new style on the fly.

We are dedicated to constantly improving our product so it will be easier to use with more flexibility, making it a valuable asset to your software product. Here, we have provided you with additional demos that may be helpful to you.