Cursors do not share the connection

[andribas404]

First of all, thanks for this project we used it in production and it is doing well!
In conjunction with the second package clickhouse-sqlalchemy we have great ORM.
However, when creating the session we have noticed that many requests connect to the server directly not using the session.
In our case URL for the server is a round-robin algorithm to select replica and we supposed that session will stick to a particular one.

Maybe there is another approach you could recommend to achieve this goal?

Describe the bug
According to PEP-249

Cursors created from the same connection are not isolated

To Reproduce

from clickhouse_driver import connect
dsn = 'clickhouse://localhost'
conn = connect(dsn)
cursor1 = conn.cursor()
cursor1.execute('CREATE TEMPORARY TABLE test_temp (x int)')
cursor1.close()
cursor2 = conn.cursor()
cursor2.execute('select * from test_temp')
cursor2.fetchall()

Throws

ServerException: Code: 60.
DB::Exception: Table default.test_temp doesn't exist.

Expected behavior

Expected behavior that table test_temp should be visible in the second cursor as here

from clickhouse_driver import connect
dsn = 'clickhouse://localhost'
conn = connect(dsn)
cursor1 = conn.cursor()
cursor1.execute('CREATE TEMPORARY TABLE test_temp (x int)')
cursor1.execute('select * from test_temp')
cursor1.fetchall() 

[]

Versions

• Version of package with the problem. 0.2.1
• Python version. 3.7