Hello guys

SQLAlchemy_test_ORM_scheme.py

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, Float, ForeignKey, DateTime
from clickhouse_sqlalchemy import Table, make_session, get_declarative_base, types, engines
from sqlalchemy.orm import relationship
from sqlalchemy import create_engine, Column, MetaData, literal

engine = create_engine('clickhouse://default:@127.0.0.1:8123/test_db')
session = make_session(engine)
metadata = MetaData(bind=engine)
Base = get_declarative_base(metadata=metadata)

class Parent(Base):
    __tablename__ = 'parent'
    id = Column(Integer, primary_key=True)
    date = Column(types.Date)
    time = Column(types.DateTime)

    children = relationship("Child", back_populates="parent")

    __table_args__ = (
        engines.MergeTree(date, (id,)),
    )

class Child(Base):
    __tablename__ = 'child'
    id = Column(Integer, primary_key=True)
    date = Column(types.Date)
    time = Column(types.DateTime)

    parent_id = Column(Integer, ForeignKey('parent.id'))
    parent = relationship("Parent", back_populates="children")

    __table_args__ = (
        engines.MergeTree(date, (id,)),
    )

if __name__ == "__main__":
    # engine = create_engine(db_connection.connection_string, echo=True)
    # engine.connect()
    # Base.metadata.drop_all(engine)
    Base.metadata.create_all(engine)