Break SQL script into list of operations for explicit transaction control.

Remove use of `executescript` method because it auto-commits on successful
execution.  Executing operations individually allows for more explicit
control of commit/rollback behavior.