是否以整数列表而不是元组列表的形式从反向关系中检索值？

from sqlalchemy import create_engine, Column, Integer, String, ForeignKey
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship, sessionmaker

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)

class Post(Base):
    __tablename__ = 'posts'
    id = Column(Integer, primary_key=True)
    user_id = Column(Integer, ForeignKey('users.id'))
    content = Column(String)
    user = relationship("User")

engine = create_engine('sqlite:///:memory:')
Base.metadata.create_all(engine)
Session = sessionmaker(bind=engine)
session = Session()

# 添加一些示例数据
user1 = User(name="Alice")
user2 = User(name="Bob")
post1 = Post(content="Hello World", user=user1)
post2 = Post(content="Another post", user=user2)
session.add_all([user1, user2, post1, post2])
session.commit()

# 使用整数列表检索
post_ids = [post.id for post in session.query(Post).all()]
print("Post IDs:", post_ids)

# 使用元组列表检索
posts_with_user_info = [(post.id, post.user.id, post.user.name) for post in session.query(Post).all()]
print("Posts with User Info:", posts_with_user_info)