Remove transaction-based tracing from sqlalchemy #7198

See parent issue.

The integration doesn't create spans on its own, but it still checks whether there are streamed or not streamed spans active and does stuff with those. Also, in the tests we parametrize on span_streaming.