按另一个连接表中的字段对连接表执行SQLAlchemy排序

from sqlalchemy import create_engine, Table, Column, Integer, String, MetaData
from sqlalchemy.orm import sessionmaker
from sqlalchemy.sql import select

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

metadata = MetaData()
connection_table = Table('连接表名称', metadata,
                         Column('字段1', Integer),
                         Column('字段2', String),
                         ...)

sorted_results = session.query(connection_table).order_by(connection_table.c.排序字段).all()

for result in sorted_results:
    # 进行操作