Adds powerful sql processing capability to your program,including sql syntax check, beautify complex sql code with lots of customizable format options,identify various database objects such as table, column, constraints in sql scripts,modify and rebuild sql on the fly, translate sql expression into a binary expression treethat ready for your further processing such as creating filter, and you take full control of sql with detailed parse tree of the whole input sql
General SQL Parser is designed to deal with SQL statement used by different Database Such as Oracle,DB2,Informix,Sybase , Postgres , MySQLand so on. And we will make it conforms to most of the entry-level SQL99 Standard.
Features overview
.NET, COM and VCL version, so it can be used in various development environment such as C#, VB .NET, VC++, VB, DELPHI, Free Pascal, Kylix
Create parser for different databases such as MSSQL,Oracle to deal with different sql dialects.
Syntax check, give the error token, position and hint message.
Pretty print SQL statements with lots of configurable parameters, make it more readable.
Modify all parts of input sql, then rebuild on the fly.
Identify various database objects such as table, field, function in sqls.
Create different visitors to visit parse tree for any purpose with the full control of all tree nodes.
Export parse tree to xml string for further processing.
Generate a list of TCustomSqlStatement objects which represent the corresponding SQL statements that have been parsed.
Parser can be instructed to ignore syntax error and continue.
Continuously check multiple SQL Statements even if there are syntax errors in some of these statements.