mysql uhex_mysql - Python-Sqlalchemy二进制列类型HEX（）和UNHEX（） - 堆栈内存溢出

仅适用于select和insert

那么，对于select你可以使用：

>>> from sqlalchemy import func

>>> session = (...)

>>> (...)

>>> engine = create_engine('sqlite:///:memory:', echo=True)

>>> q = session.query(Model.id).filter(Model.some == func.HEX('asd'))

>>> print q.statement.compile(bind=engine)

SELECT model.id

FROM model

WHERE model.some = HEX(?)

对于插入：

>>> from sqlalchemy import func

>>> session = (...)

>>> (...)

>>> engine = create_engine('sqlite:///:memory:', echo=True)

>>> m = new Model(hash=func.HEX('asd'))

>>> session.add(m)

>>> session.commit()

INSERT INTO model (hash) VALUES (HEX(%s)