Some links on SQL parsing
Posted by jpluimers on 2019/10/10
Sometimes you want the opposite of SQL generation (which most, if not all, ORMs do behind the scenes): SQL parsing.
Some links that should get me started:
- [WayBack] GOLD Parsing System – A Free, Multi-Programming Language, Parser Generator
- [WayBack] SQL Parse, Analyze, Transform and Format All In One
- [WayBack] Need in SQL parser on Delphi – Stack Overflow
- [WayBack] Visual SQL Query Builder component for Delphi and C++ Builder
Visual SQL Query Builder, SQL Parser and Analyser component for Delphi and C++Builder for use with VCL, TNT or DevExpress controls
- [WayBack] ZeosLib download | SourceForge.net
The ZeosLib is a set of database components for MySQL, PostgreSQL, Interbase, Firebird, MS SQL, Sybase, Oracle and SQLite for Delphi, FreePascal/Lazarus, Kylix and C++ Builder.
- [WayBack] SQL Parser for Delphi download | SourceForge.net
Download SQL Parser for Delphi for free. Develope a string parser that is capable to parse SQL statements into tokens, allows changing theese tokens and rebuilding (modified) SQL statement
- [WayBack] Felix Colibri- Delphi SQL Parser
- [WayBack] Visual SQL Query Builder component for Delphi and C++ Builder
–jeroen
The Wiert Corner - irregular stream of stuff 
thaddy said
Examining the Freepascal sources is a good idea anyway and should be on your todo list:
There are many gems to be found that are equally good for Delphi too.
Some Delphi programmers tend to ignore this rich source of very high quality well maintained and well documented Object Pascal sourcecode.
thaddy said
You may also want to inspect the sources from the fcl-db package in Freepascal: contains a full (a.o.) Firebird compatible Sql parser, scanner and syntax tree.
Can be made to compile in Delphi with little effort. And it is best in class.