I'm developing a commercial application that uses Firebird. At the
moment I have all my queries coded in stored procedures.

The process to deploy updates to my app I think is going to be
painful, because for example, in order to modify a field I have to
delete every stored procedure that reference that field, make the
modifications and recreate the stored procedures.

I'm thinking of dropping all my stored procedures and use dynamic sql
directly from my code instead.

I would like to know your opinion about this. What drawbacks can I
expected?