Add transaction accessor in `Connection`

[FroMage]

Once a transaction has been created with Connection.begin it will be associated with the connection, so its implementation keeps it in a field.

It can be useful to add an accessor for it, so that we can check if a connection is in a transaction already, and to obtain the transaction without having to hang on to the connection/transaction tuple.