SQLAchemy ORM:在TRUE上左联接横向()

from sqlalchemy import create_engine, 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 Address(Base):
    __tablename__ = 'addresses'
    id = Column(Integer, primary_key=True)
    user_id = Column(Integer)
    email = Column(String)

# 左联接查询
query = session.query(User, Address).join(Address, User.id == Address.user_id, isouter=True)

# 横向连接查询
query = session.query(User, Address).cross_join(Address)

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

# 打印结果
for user, address in results:
    print(user.name, address.email)