列是另一字符串的子字符串的SQLAlchemy查询

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, String

# 创建数据库连接
engine = create_engine('数据库连接字符串')
Session = sessionmaker(bind=engine)
session = Session()

# 定义数据表模型
Base = declarative_base()

class MyTable(Base):
    __tablename__ = 'my_table'
    id = Column(String, primary_key=True)
    column1 = Column(String)

# 查询列是另一字符串的子字符串的记录
sub_string = '子字符串'
query = session.query(MyTable).filter(MyTable.column1.like(f'%{sub_string}%'))
result = query.all()

# 打印查询结果
for row in result:
    print(row.id, row.column1)