Improve cursor close and connection close behaviour

[hashhar]

From https://github.com/trinodb/trino-python-client/pull/405#issuecomment-1705226919

In my head the logic should be:

• On cursor.close()
  • Cancel any already executing queries if they exist
  • Perform implicit ROLLBACK if within a transaction
  • Set some boolean so that calling any method of the cursor leads to Error

We don't do steps 2 and 3 here (both required by DB-API).

• On cursor.cancel() - this is not a DB-API specified method so the behaviour is up to us to specify
  • Cancel any already executing queries
    • If query already finished, return False
    • If query is running and was cancelled successfully, return True
    • If no query was executed at all (how to differentiate between this and already finished? - presence of query on the cursor?) then raise Exception

[hashhar]

We can focus on implementing "Set some boolean so that calling any method of the cursor leads to Error" for cursor.close() as that's the main thing we are missing. Transactions are not supported properly anyway so whether we ROLLBACK or not doesn't seem important for now