Pending migrations and multi-statement executes

-default to pending migrations only
-support multi-statement scripts (like create procedure)