Avoid transaction context-managers for legacy SQL drivers (GH8277)

Eliminating contextmanager based transaction-handling

Rewriting as contextmanager

Code review fixes

Changing sqlalchemy version to 0.7.10 for python2.6