DBAPI doesn't support CREATE TABLE or other none-returning queries

Describe what's wrong

CHDB's dbapi implementation does not work for basic queries like CREATE TABLE that return no data. I am using DBAPI for sqlalchemy compatibility.

Does it reproduce on recent release?

Yes, reproduced on chdb==1.0.2

How to reproduce

import chdb.dbapi as dbapi
conn1 = dbapi.connect()
cur1 = conn1.cursor()
cur1.execute("""CREATE TABLE rate (
    day Date, 
    value Int32
) ENGINE = Memory""")

Expected behavior

Execute succeeds without an exception

Error message and/or stacktrace

---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
File ~/venv/lib/python3.11/site-packages/chdb/dbapi/connections.py:185, in CHDBResult.read(self)
    184 try:
--> 185     data = json.loads(self.connection.resp)
    186 except Exception as error:

File /usr/local/lib/python3.11/json/__init__.py:339, in loads(s, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw)
    338 if not isinstance(s, (bytes, bytearray)):
--> 339     raise TypeError(f'the JSON object must be str, bytes or bytearray, '
    340                     f'not {s.__class__.__name__}')
    341 s = s.decode(detect_encoding(s), 'surrogatepass')

TypeError: the JSON object must be str, bytes or bytearray, not NoneType

During handling of the above exception, another exception occurred:
...
File ~/venv/lib/python3.11/site-packages/chdb/dbapi/connections.py:187, in CHDBResult.read(self)
    185     data = json.loads(self.connection.resp)
    186 except Exception as error:
--> 187     raise err.InterfaceError("Unsupported response format:" % error)
    189 try:
    190     self.field_count = len(data["meta"])

TypeError: not all arguments converted during string formatting

Additional context

This seems to work fine in the non DBAPI implementation.

chdb-io / chdb

DBAPI doesn't support CREATE TABLE or other none-returning queries #162