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.

SQL Parser can even do more

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.

Click the database logos on the right side of this page to view the supported SQL of each database.

Any questions? Feel free to submit your request here.

  

Supported Database

 

Google BigQuery

 

Couchbase database

 

IBM DB2 database

 

EMC Greenplum

 

SAP Hana

 

hadoop hive

 

Impala

 

IBM Informix database

 

MySQL database

 

Netezza database

 

Openedge database

 

Oracle database

 

PostgreSQL database

 

Amazon redshift

 

Snowflake SQL

 

Spark SQL

 

Microsoft SQL Server database

 

Sybase database

 

Teradata database

 

Vertica database

 

Microsfot Office Access database