SQLalchemy:选择与另一个表具有多对多关系的所有行

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Table, Column, Integer, ForeignKey
from sqlalchemy.orm import relationship

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

Base = declarative_base()

class Table1(Base):
    __tablename__ = '表1'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    table2 = relationship('Table2', secondary='中间表')

class Table2(Base):
    __tablename__ = '表2'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    table1 = relationship('Table1', secondary='中间表')

class MiddleTable(Base):
    __tablename__ = '中间表'
    table1_id = Column(Integer, ForeignKey('表1.id'), primary_key=True)
    table2_id = Column(Integer, ForeignKey('表2.id'), primary_key=True)

rows = session.query(Table1).filter(Table1.table2.any(Table2.name == '目标表2的名称')).all()