Interbase Stored Procedure Grammar
One of our customer recently wanted to perform some heavy duty computations on his Interbase Stored Procedures (analysis and transformations).
Instead of plunging head on in an ad-hoc tool, we started to build a general parser. So we had to start-off with a BNF grammar. We already presented a simplified Sql grammar for the main INSERT, UPDATE, DELETE and SELECT requests. So we extended this grammar to handle the stored procedures as well.
Most of the grammar applies to Firebird as well. You can read the full article here.