Cleanup EmbeddedRelationalConnection #3296
Description
It would be nice to rewrite this class, and make consistent reasoning about the nullability of certain attributes that guide the actual behavior of it. Plus fixing some incorrect casting of the underlying (optional) transaction.