Need in SQL parser on Delphi

Question

Does anybody know about good SQL parser with sources, written in Delphi? I need in parsing SQL commands (with all new features of Firebird 2.5) into object structure.

Answer 1

Read this article for Delphi SQL Parser, it uses IB as database but should not be very different between it and FB.

And there's an open source project called SQL Parser for Delphi but hasn't updated since 2005, but it may give you start up point.

Answer 2

2 other native Delphi SQL parsers:

• Zeoslib seems to have an sql parser to parse Interbase, MySQL, Oracle, Postgres, SqLite and Sybase.

• General SQL Parser (commercial)