General SQL Parser is developed to help people who want to check syntax of SQL statements, pretty print out SQL statements,and parse SQL statements into a parse tree in their own program.
General SQL Parser provides detail information about a SQL statement such as statement types (Select, insert, update, delete or create and so on), what's tables and fields are used in a statement, and different parts of a SQL statement are also available such as where clause, group by clause and having clause and so on...
General SQL Parser is designed to deal with SQL statement used by different Database Such as Oracle,DB2,Informix,Sybase,Postgres,MySQL and so on. And we will make it conforms to most of the entry-level SQL99 Standard
Here are some key features of "General SQL Parser":
· Create different parser type such as geneirc or oracle to deal with different sql dialect.
· Syntax check, give the error token, position and hint message.
· Modify all parts of input sql, then rebuild on the fly.
· Print out SQL statements pretty, make it more readable.
· Continuously check multiple SQL Statements even if there are syntax errors in some of these statements.
· Generate a list of TCustomSqlStatement objects which represent the corresponding SQL statements that have beed parsed.
· Parser can be instructed to ignore syntax error and continue.
What's New in This Release:
· Better support of MSSQL sql dialect.
· IPretty print of select,insert,update,delete and create table statement are supported.
· Fix some minor bugs reported by users.
|