Fix backpressure with TLS streams

[vobarian]

I'm creating this issue to point to the pull request I created to fix it, #1559. In short, stream backpressure does not work when using TLS connections, which can cause out of memory errors when the buffer grows too large. This occurs in both directions: sending streaming data with LOAD DATA LOCAL and receiving streaming result sets with connection.query().stream(). More details are in the PR comments.

[wellwelwel]

Closed in #1752. Thanks, @vobarian! 🤝