sqlite push should be in transaction

It seems the sql commands executed by push:sqlite aren't inside a transaction.

I'd expect them to be in a transaction, so that if I encounter an error part way through my database isn't left in a weird state and is instead rolled back to where it was prior to the push