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
Merge pull request #8278 from artemyk/remove_context_transactions

Eliminating contextmanager based transaction-handling