add support for migrations that cannot be run in a transaction