如何使用SQLAlchemy执行自引用相关子查询？

from sqlalchemy import create_engine, select
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

engine = create_engine('your_database_connection_string')
Session = sessionmaker(bind=engine)
session = Session()

Base = declarative_base()

class YourModel(Base):
    __tablename__ = 'your_table_name'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    parent_id = Column(Integer, ForeignKey('your_table_name.id'))

stmt = session.query(YourModel).\
    filter(YourModel.parent_id == session.query(YourModel.id).\
        filter(YourModel.name == 'your_parent_name')).\
    statement

subquery = session.query(YourModel).\
    filter(YourModel.parent_id == session.query(YourModel.id).\
        filter(YourModel.name == 'your_parent_name')).\
    subquery()

result = session.query(YourModel).\
    filter(YourModel.parent_id.in_(subquery)).\
    all()

for row in result:
    print(row.id, row.name)