def entries_count(cls, cond):
    return select([func.count(Entry.id)]).where((Entry.author_id == cls.id) &
        cond).as_scalar()
session.query(User, User.entries_count(Entry.date > start_date))
Динамическое свойство column_property с SQLAlchemy