如何检索候选实体中自定义字段的特定值

SELECT * FROM candidates WHERE custom_field1 = '特定值';

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

Base = declarative_base()

class Candidate(Base):
    __tablename__ = 'candidates'
    id = Column(Integer, primary_key=True)
    custom_field1 = Column(String)
    custom_field2 = Column(String)

engine = create_engine('sqlite:///example.db')
Session = sessionmaker(bind=engine)
session = Session()

# 检索 custom_field1 等于 '特定值' 的记录
results = session.query(Candidate).filter(Candidate.custom_field1 == '特定值').all()
for result in results:
    print(result.id, result.custom_field1, result.custom_field2)

CREATE INDEX idx_custom_field1 ON candidates(custom_field1);

SELECT * FROM candidates WHERE CAST(custom_field1 AS VARCHAR) = '特定值';