Parsing, formatting, modification and analysis

Offline SQL syntax check

Validates syntax without connecting to a database

In-depth analysis of SQL script

Prepares a detailed SQL parse tree node structure

Custom SQL engine for various databases

Includes query parser for SQL Server, Oracle, DB2, MySQL, Teradata, PostgreSQL and ACCESS

Highly customizable SQL formatter

Highlights syntax with more than 80 format options

Fully access to SQL query parse tree

Fetching, modifying and rewriting SQL segment have never been so easy

Major programming language support

SQL parser for C#, VB.NET, Java, C/C++, Delphi, VB

Why do people choose to use our powerful SQL Parser?

What can this SQL Parser do for you?

Clean up messy SQL codes

Easily integrate SQL formatter into your application to generate a color coded, professional, and intuitive SQL layout, giving your product a professional feeling.

Detect SQL syntax errors

Your application will be able to validate SQL syntax before a database executes the query. This is very useful especially if your SQL was dynamically built based on user input.

Rid SQL injections

Avoid being vulnerable to SQL injection on your ASP.NET or Java application, by automatically detecting malicious SQL segment with our operational library.

Retrieve/Refactor table & column name

Precisely determining and renaming every table and column in stored SQL statements is very complex with a lot of nesting and sub-queries. With us, however, that tedious procedure can become hassle-free one for you.

Find affected SQL objects

Parse out the affected SQL objects in a SQL file that can have many different types of SQL (select, insert, create, drop, etc). this can help determine what is being affected, including but not limited to schema, table, column.

Discover the relationship in DDL

Quickly locate the primary key and/or foreign key in DDL scripts to figure out the complex relationship between the various tables. Extracted table, attribute names, data types can all be used to generate the CRUD-Statements.

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.

Rewrite and convert SQL

Modify SQL expression/condition in where clause to reconstruct a new filter. Rewrite Oracle proprietary joins to ANSI SQL compliant joins. Translate SQL between different databases.

CRUD Reportor

Read complex and large SQL scripts to find out tables have Create, Read, Update, Delete and Insert operations against them immediately, it's almost impossible to do that without help with a tool.

Impact and Data Lineage

Determining the impact and data lineage for database objects. capture and represent column level data lineage between applications; find table/view and column references and more.

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.

Questions?

If you have any questions about General SQL Parser, You can always send us an email and we'll get back to you within 24 hours.