example sqlalchemy ORM query

gistfile1.py

# get count of users by birthday who've clicked in the last 7 days
results = session.query(User)\
                 .join(Click, User.id == Click.user_id)\
                 .filter(Click.created_at > datetime.datetime.today() - datetime.timedelta(days=7))\
                 .groupby(User.birthday)\
                 .orderby(User.birthday)\
                 .values(User.birthday,
                         func.count(func.distinct(User.id)))