sqlalchemy结果到字典

from sqlalchemy import create_engine, MetaData, Table
from sqlalchemy.orm import sessionmaker
from sqlalchemy.orm.util import _entity_descriptor

def result_to_dict(result):
    if isinstance(result, list):
        return [result_to_dict(row) for row in result]
    elif hasattr(result, '__table__'):
        return {c.name: getattr(result, c.name) for c in result.__table__.columns}
    elif hasattr(result, '_asdict'):
        return result._asdict()
    elif hasattr(result, '__dict__'):
        return {k: result_to_dict(v) for k, v in result.__dict__.items() if not k.startswith('_')}
    else:
        return result

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

# 执行查询
query = session.query(Table)
results = query.all()

# 将查询结果转换为字典
dict_results = result_to_dict(results)
print(dict_results)