General SQL Parser is a software designed to assist users in checking, formatting, and parsing SQL statements into a parse tree within their program.
I recently had the opportunity to utilize the General SQL Parser, and I must say I am thoroughly impressed. This software application is designed to accommodate SQL statements used by various databases such as Oracle, DB2, Informix, Sybase, Postgres, MySQL, and much more.
One of the features that stood out to me was the parser's ability to create a parser for different databases like MSSQL, Oracle, to deal with different SQL dialects. It also performs a syntax check and provides the error token, position, and hint message to support users in rectifying mistakes.
Another impressive feature is the parser's ability to modify all parts of input SQL and rebuild it on the fly. Additionally, it identifies various database objects such as tables, fields, functions in SQL statements. This allows for accurate handling of user commands.
Furthermore, the software generates a list of TCustomSqlStatement objects that represent the corresponding SQL statements that are parsed. And users can configure the PDF output to reflect readable SQL statements with lot's of configurable parameters.
The ability to produce different visitors to visit parse trees and control all tree nodes for any purpose is also a noteworthy feature. Furthermore, the parser can ignore syntax errors and continue with the process, even when multiple SQL statements are continuously checked.
Overall, I found that the General SQL Parser is a reliable and adaptable tool for dealing with SQL statements across various databases. It conforms to most of the entry-level SQL92 standard and makes SQL statement processing simpler for developers. I recommend this software application to all SQL programmers out there.
One of the features that stood out to me was the parser's ability to create a parser for different databases like MSSQL, Oracle, to deal with different SQL dialects. It also performs a syntax check and provides the error token, position, and hint message to support users in rectifying mistakes.
Another impressive feature is the parser's ability to modify all parts of input SQL and rebuild it on the fly. Additionally, it identifies various database objects such as tables, fields, functions in SQL statements. This allows for accurate handling of user commands.
Furthermore, the software generates a list of TCustomSqlStatement objects that represent the corresponding SQL statements that are parsed. And users can configure the PDF output to reflect readable SQL statements with lot's of configurable parameters.
The ability to produce different visitors to visit parse trees and control all tree nodes for any purpose is also a noteworthy feature. Furthermore, the parser can ignore syntax errors and continue with the process, even when multiple SQL statements are continuously checked.
Overall, I found that the General SQL Parser is a reliable and adaptable tool for dealing with SQL statements across various databases. It conforms to most of the entry-level SQL92 standard and makes SQL statement processing simpler for developers. I recommend this software application to all SQL programmers out there.
What's New
Version 0.9.1: Performance improved
Version 0.6.0: N/A