table = Table('table', metadata, Column('primary_key', Integer), Column(
    'other_column', Integer))
print(select([func.count()]).select_from(table))
How to count rows with SELECT COUNT(*) with SQLAlchemy?