如何向过滤查询添加新字段

-- 假设我们要查询年龄大于30的员工，并且添加部门信息
SELECT id, name, age, department
FROM employees
WHERE age > 30;

from sqlalchemy import create_engine, Table, Column, Integer, String, MetaData, select

engine = create_engine('sqlite:///example.db')
metadata = MetaData()

employees = Table('employees', metadata,
                 Column('id', Integer, primary_key=True),
                 Column('name', String),
                 Column('age', Integer),
                 Column('department', String))

# 构建查询
stmt = select([employees.c.id, employees.c.name, employees.c.age, employees.c.department]).where(employees.c.age > 30)

with engine.connect() as conn:
    result = conn.execute(stmt)
    for row in result:
        print(row)