Additionally sqldb's TSQLScript does not deal correctly with stored procedure creation parts - it seems to split those up in different statements.
Most likely, there will need to be a separate TIBSQLScript that completely parses the SQL for this to work. Although there is an SQL parser included with FPC, this parser currently throws errors parsing the employee.fdb script, so it would need to be improved. Some improvements have already been made but e.g. SET TERM support still needs to be added.
(This bug was raised to keep track of underlying problems; the problems appear to be in FPC's sqldb, not in turbobird)
Running the DDL script generated by running Script database on the Firebird 2.5 sample employee database fails.
See FPC bug http://bugs.freepascal.org/view.php?id=26137
Additionally sqldb's TSQLScript does not deal correctly with stored procedure creation parts - it seems to split those up in different statements.
Most likely, there will need to be a separate TIBSQLScript that completely parses the SQL for this to work. Although there is an SQL parser included with FPC, this parser currently throws errors parsing the employee.fdb script, so it would need to be improved. Some improvements have already been made but e.g. SET TERM support still needs to be added.