we should not execute USE <db> through clickhouse_api.execute_command instead we should have ch_api.set_database function

[iamtalhaasghar]

Use Case Description

we should not execute USE through clickhouse_api.execute_command instead we should have ch_api.set_database function

Proposed Solution

Just like we have set_database function in mysql_api

Alternatives Considered

tried making get_tables smart if self.database is set then show those tables but it breaks because the client expects tables from another db bcz USE was invoked.

Additional Context

underlying details should be abstracted from client as much as we can and doing USE kinda breaks that philosophy....