我不知道如何在sqlalchemy中创建此MySQL语句

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

engine = create_engine('mysql://username:password@host:port/database')

Base = declarative_base()

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

Base.metadata.create_all(engine)

Session = sessionmaker(bind=engine)
session = Session()

data = MyTable(name='example')
session.add(data)
session.commit()

result = session.query(MyTable).all()
for row in result:
    print(row.name)