SQL Parser How-To

Read SQL text, and it will be tokenlized by lexer into list of tokens. This list of source tokens will be used as the input of the yacc parser.

Yacc parser reads source token in SourceTokenList, based on the syntax of different databases SQL dialect, the parser will create a query parse tree if no syntax error was found. Otherwise, syntax error will be detected.

Translate the raw query parse tree into a formal parse tree, top level node of the formal parse tree is type of sql statements: such as TSelectSqlStatement, TInsertSqlStatement, TDeleteSqlStatement, TUpdateSqlStatement, TCreateTableSqlStatement and etc. which in turn includes other sub parse tree nodes.

 

Supported Database

 

Oracle database

 

Microsoft SQL Server database

 

IBM DB2 database MySQL database Sybase database

 

Teradata database

 

PostgreSQL database

 

Netezza database

 

Microsfot Office Access database
Download General SQL Parser