Rename get_transaction to get_cursor

This keeps us closer to the DB-API 2.0 object model, where there is no
transaction object per se. Rather a transaction is a function of the way
the connection object underlying a cursor is used.