gistfile1.txt

# AND OR とかも直感的に使える
from sqlalchemy.sql.expression import *

# AND
Entry.query.filter(and_(Entry.id == 1, Entry.text == "entry")).all()
# => SELECT * FROM entries WHERE entries.id = 1 AND entries.text = "entry"

# OR
Entry.query.filter(or_(Entry.id == 1, Entry.text == "entry")).all()
# => SELECT * FROM entries WHERE entries.id = 1 OR entries.text = "entry"

# IN
Entry.query.filter(Entry.id.in_([1, 2, 3])).all()
# => SELECT * FROM entries WHERE entries.id IN (1, 2, 3)

# NOT IN
Entry.query.filter(not_(Entry.id.in_([1, 2, 3]))).all()
# => SELECT * FROM entries WHERE entries.id NOT IN (1, 2, 3)

# LIKE
Entry.query.filter(Entry.text.like("ent%")).all()
# => SELECT * FROM entries WHERE entries.id LIKE "ent%"