在sqlalchemy中返回带有join的完整语句

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

# 创建引擎和元数据
engine = create_engine('数据库连接字符串')
metadata = MetaData(bind=engine)

# 定义表结构
users = Table('users', metadata,
              Column('id', Integer, primary_key=True),
              Column('name', String),
              Column('email', String)
              )

orders = Table('orders', metadata,
               Column('id', Integer, primary_key=True),
               Column('user_id', Integer),
               Column('product', String),
               Column('quantity', Integer)
               )

# 构建查询语句
stmt = select([users.c.name, orders.c.product]).join(orders, users.c.id == orders.c.user_id)

# 执行查询并获取结果
result = engine.execute(stmt)

# 输出结果
for row in result:
    print(row)