dbi: Provide transaction support in the Connection base class

* Move postgres routines to Connection
* Remove default implementation from MySQL
* Add custom beginTransaction to SQLite