Remove auto-transaction behavior from main instance

[andrewosh]

When you do an await db.insert(...) on the primary db instance, that should internally be fully committed without requiring an additional db.flush().

If the user wants transaction behavior, they should explicitly use db.transaction().