在SQL工作台和SQL-alchemy for distinct中获取不同的查询结果

SELECT DISTINCT column1, column2, ...
FROM table_name
WHERE condition;

from sqlalchemy import create_engine, distinct
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 MyTable(Base):
    __tablename__ = 'table_name'
    column1 = Column('column1', String)
    column2 = Column('column2', String)

# 查询不同的结果
distinct_results = session.query(distinct(MyTable.column1), MyTable.column2).filter(condition).all()