Adds powerful sql processing capability to your program
Provides powerful sql processing capacity to your program, including sql syntax check, beautify complicated sql code with a lot of customizable format choices, identify various database items such as table, line, constraints in sql scripts, modify and rebuild sql on the fly, convert sql expression into the binary expression treethat prepared for your further control such as creating filtration system, and you take complete control over sql with comprehensive parse tree of the particular whole input sql
Common SQL Parser is created to deal with SQL statement used by various Database For example Oracle, DB2, Informix, Sybase, Postgres, MySQL and so on. And well make it conforms in order to most from the entry-level SQL99 Standard.
Features overview
. INTERNET, COM and VCL edition, so it can be utilized inside various development environment for example C#, VB. NET, VC, VB, DELPHI, Free Pascal, Kylix
Create parser for various databases such as MSSQL, Oracle to deal along with different sql dialects.
Format check, give the mistake token, position and tip message.
Pretty print SQL statements with lots associated with configurable parameters, make this more readable.
Modify just about all parts of input sql, then rebuild on the particular fly.
Identify various data source objects for example table, industry, function in sqls.
Generate different people to visit parse tree for almost any purpose along with the full control over just about all tree nodes.
Export parse tree to xml thread for further processing.
Create a list of TCustomSqlStatement objects which represent the particular corresponding SQL statements that will have been parsed.
Parser can be instructed in order to ignore syntax error plus continue.
Continuously check a number of SQL Statements even when there are syntax mistakes in some of these types of statements.
|