D1 in a Durable Object transaction instead

1. The sql generated in migrations doesn't have IF NOT EXISTS in CREATE TABLE statements which causes errors while re-running the migrations against the db where the table already exists so I've to manually add it.
2. I'm getting ERROR] A prepared SQL statement must contain only one statement. [code: 7500] even though all sql statements have semicolon at the end.
3. Is there a way to do CI-CD with drizzle. I want to use do migrations from my github actions?

1. is probably best handled via a github issue to their repo
2. there's a bug in our sql parser/splitter at the moment - is there a comment at the start of the file by any chance?
3. not sure about that one

1. Insert a row that is enforced unique
2. Fetch some external service
3. Rollback 1 if 2 fails, else commit

1. Oh come on! Yes!! Drizzle generated whole bunch of comments before sql statements I removed them and it worked!!! Thanks Max.

1. Start DO tx to acquire lock
2. Fetch external service
3. Rollback if 2 fails
4. Insert D1 row to record 2 happened
5. Commit