create table with sql ERROR

[codingMrHu]

sql = "CREATE TABLE component_center.test_0204 (`id` Int null,`title` String null,`flag` Int null)ENGINE = TinyLog() ;"
session.execute(sql)

get ERROR:

   self.execute(sql)
  File "D:\proj\python\component_center\app\dbs\clickhouse.py", line 176, in execute
    return self.__edit(sql)
  File "D:\proj\python\component_center\app\dbs\clickhouse.py", line 184, in __edit
    res = self.cursor.execute(sql)
  File "D:\python3.6\lib\site-packages\sqlalchemy\orm\session.py", line 1292, in execute
    clause, params or {}
  File "D:\python3.6\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
    return meth(self, multiparams, params)
  File "D:\python3.6\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "D:\python3.6\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
    distilled_params,
  File "D:\python3.6\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
    e, statement, parameters, cursor, context
  File "D:\python3.6\lib\site-packages\sqlalchemy\engine\base.py", line 1514, in _handle_dbapi_exception
    util.raise_(exc_info[1], with_traceback=exc_info[2])
  File "D:\python3.6\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
    raise exception
  File "D:\python3.6\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
    cursor, statement, parameters, context
  File "D:\python3.6\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
    cursor.execute(statement, parameters)
  File "D:\python3.6\lib\site-packages\sqlalchemy_clickhouse\connector.py", line 212, in execute
    self._process_response(response)
  File "D:\python3.6\lib\site-packages\sqlalchemy_clickhouse\connector.py", line 343, in _process_response
    for r in response:
  File "D:\python3.6\lib\site-packages\infi\clickhouse_orm\database.py", line 240, in select
    r = self._send(query, settings, True)
  File "D:\python3.6\lib\site-packages\sqlalchemy_clickhouse\connector.py", line 103, in _send
    raise Exception(r.text)
Exception: Code: 62, e.displayText() = DB::Exception: Syntax error (Multi-statements are not allowed): failed at position 111 (end of query): ; FORMAT TabSeparatedWithNamesAndTypes.  (version 20.10.3.30 (official build))

sqlalchemy_clickhouse/connector.py line 209
change the sql to-->
CREATE TABLE component_center.test_0204 (id Int null,title String null,flag Int null)ENGINE = TinyLog() ; FORMAT TabSeparatedWithNamesAndTypes

so it ERROR!
how can I do ??

[codingMrHu]

basic DDL error too!

    def _create_engine(self):
        engine = create_engine('clickhouse://{}:{}@{}:{}/{}'.format(self.username,self.password,self.host,self.port,self.db),encoding=self.charset)
        print('create_engine----',engine)
        return engine

    def create_table(self, table_name, item):
        # 构造sql语句创建表 指定引擎默认为TinyLog
        # TinyLog 表经常作为中间表，用于数据的微批量处理. 语法中无需携带任何参数
        metadata = MetaData(bind=self._create_engine())

        day  = Table('date_my',metadata,
                      Column('day',types.Date,primary_key=True),
                      Column('value',types.Integer,server_default=literal(1)),
                      engines.Memory()
                      )
        day.create()

  File "D:\proj\python\component_center\app\dbs\clickhouse.py", line 93, in create_table
    day.create()
  File "D:\python3.6\lib\site-packages\sqlalchemy\sql\schema.py", line 928, in create
    bind._run_visitor(ddl.SchemaGenerator, self, checkfirst=checkfirst)
  File "D:\python3.6\lib\site-packages\sqlalchemy\engine\base.py", line 2095, in _run_visitor
    conn._run_visitor(visitorcallable, element, **kwargs)
  File "D:\python3.6\lib\site-packages\sqlalchemy\engine\base.py", line 1656, in _run_visitor
    visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
  File "D:\python3.6\lib\site-packages\sqlalchemy\sql\visitors.py", line 145, in traverse_single
    return meth(obj, **kw)
  File "D:\python3.6\lib\site-packages\sqlalchemy\sql\ddl.py", line 832, in visit_table
    include_foreign_key_constraints,  # noqa
  File "D:\python3.6\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
    return meth(self, multiparams, params)
  File "D:\python3.6\lib\site-packages\sqlalchemy\sql\ddl.py", line 72, in _execute_on_connection
    return connection._execute_ddl(self, multiparams, params)
  File "D:\python3.6\lib\site-packages\sqlalchemy\engine\base.py", line 1073, in _execute_ddl
    compiled,
  File "D:\python3.6\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
    e, statement, parameters, cursor, context
  File "D:\python3.6\lib\site-packages\sqlalchemy\engine\base.py", line 1514, in _handle_dbapi_exception
    util.raise_(exc_info[1], with_traceback=exc_info[2])
  File "D:\python3.6\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
    raise exception
  File "D:\python3.6\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
    cursor, statement, parameters, context
  File "D:\python3.6\lib\site-packages\sqlalchemy\engine\default.py", line 608, in do_execute
    cursor.execute(statement, parameters)
  File "D:\python3.6\lib\site-packages\sqlalchemy_clickhouse\connector.py", line 210, in execute
    self._process_response(response)
  File "D:\python3.6\lib\site-packages\sqlalchemy_clickhouse\connector.py", line 341, in _process_response
    for r in response:
  File "D:\python3.6\lib\site-packages\infi\clickhouse_orm\database.py", line 240, in select
    r = self._send(query, settings, True)
  File "D:\python3.6\lib\site-packages\sqlalchemy_clickhouse\connector.py", line 103, in _send
    raise Exception(r.text)
Exception: Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 96 ('FORMAT') (line 8, col 2): FORMAT TabSeparatedWithNamesAndTypes. Expected one of: storage definition, ENGINE (version 20.10.3.30 (official build))