Syntax error in multi statement migration puts you in a bad state about migrant

[jaemk]

There's a note in the readme that should probably be larger

Note: SQL statements are batch executed as is. If you want your migration to happen atomically in a transaction you must manually wrap your statements in a transaction (begin transaction; ... commit;).

That requirement stems from two things:

1. going with the lowest common denominator, mysql doesn't support migrations in transaction
2. an original "feature" of this tool where it would fallback to using the command line utilities (psql, sqlite, mysqlsh) if the CLI was compiled without the database driver libraries.

Number 2 is no longer a "feature", now it's just tech debt that I need to get rid of - after that, db's that support ddl changes in transactions can run all migration sql in a transaction automatically.

[Bachmann1234]

:doh: thats what I get for not reading the readme close enough