General SQL Parser 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 tree
that 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, SQL Server, DB2, Informix, Sybase, Postgres, MySQL and so on.
It conforms to most of the entry-level SQL99 Standard.
"Click here to check how it can help you in many ways!"
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
- Pretty print SQL statements with lots of configurable parameters, make it more readable.
- Identify various database objects such as table, field, relationship between field and table,
function, procedure and trigger in sqls.
- Preventing SQL injection/attacks.
- Syntax check, given the error token, position and hint message.
- Create/modify different parts of SQL query, then build/rebuild on the fly.
- Internal SQL engine for different databases including SQL Server, Oracle, MySQL, DB2 and Access.
- Create different visitors to visit parse tree for any purposes with the full control of all tree nodes.
- Export parse tree to xml format 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.
"Need a Java version of general sql parser? Sign up now to join the beta!"
COPYRIGHT (C) 2001-2010 sqlparser.com , privacy policy ALL RIGHT RESERVED
|
