python - SQLAlchemy 如何检查一个值是否介于两列的值之间？

Question

如何检查条件值是否介于 column1 和 column2 之间？

MySQL:

select
    *
from
    tablename
where
    '2014-01-01' between start_date and end_date

SQL炼金术:

select(
  [table.c.id],
  and_('2014-01-01'.between(start_date, end_date))
)

这可能吗？

Answer 1

from sqlalchemy import literal

literal('2014-01-01').between(x, y)