SET TRANSACTION and COMMIT [WORK] are not supported in migrations. COMMIT RETAIN can be used, but this will only
allow partial rollback of a migration; only statements after the last COMMIT RETAIN can be rolled back.
Migrations modifying or dropping objects while the database is in use can result in long delays or “object X is in use”
errors as Firebird uses existence locks on metadata objects when they are in use. It may be necessary to shut down the
database and run the migration with exclusive access.