The Connection API is confusing

[Changaco]

Reticketing from #82 (comment):

The remaining issue is that with conn.cursor() as cursor and with conn.get_cursor() as cursor are now both valid but behave differently: the latter commits or rolls back at the end whereas the former only closes the cursor.