使用SQL和Sqlalchemy查询的表具有相同的列名

SELECT A.column_name AS A_column, B.column_name AS B_column
FROM A
JOIN B ON A.id = B.id;

SELECT A.column_name, B.column_name
FROM A
JOIN B ON A.id = B.id;

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

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

# 定义表A和B的映射类
class TableA(Base):
    __tablename__ = 'A'
    id = Column(Integer, primary_key=True)
    column_name = Column(String)

class TableB(Base):
    __tablename__ = 'B'
    id = Column(Integer, primary_key=True)
    column_name = Column(String)

# 查询表A和B的column_name列
results = session.query(TableA.column_name, TableB.column_name).join(TableB, TableA.id == TableB.id).all()