在(0..1)一对一关系中，SQLAlchemy核心select from join tables会引发不明确的名称InvalidRequestError

from sqlalchemy import create_engine, select, join, alias, Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

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

# 创建基类
Base = declarative_base()

# 定义表模型
class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    # ...

class Profile(Base):
    __tablename__ = 'profiles'
    id = Column(Integer, primary_key=True)
    user_id = Column(Integer, ForeignKey('users.id'))
    # ...

# 创建别名
users_alias = alias(User)
profiles_alias = alias(Profile)

# 构建查询
query = select([users_alias.c.name, profiles_alias.c.user_id]).select_from(
    join(users_alias, profiles_alias, users_alias.c.id == profiles_alias.c.user_id)
)

# 执行查询
result = session.execute(query)

# 处理查询结果
for row in result:
    print(row)

# 关闭会话
session.close()