SQLalchemy select column and COUNT(column)

Question

I'm trying to imitate such query in sqlalchemy: SELECT col1, COUNT(col1) FROM "table" (simplified case)

According to this answer, I found how to count a single column, but not a column - COUNT(column) pair.

The answer from a link: session.query(MyTable.col1).count()

My current case: db.query(models.User.places).filter(models.User.id == 10).all() (Also want to get a count of places)

CodeMantle · Accepted Answer · 2021-01-11 12:54:25Z

1

This will count the occurrence of places alongside the places value, grouped by User id:

from sqlalchemy import func

cs.query(User.id, User.places, func.count(User.places)).group_by(User.id).all()

Is that what you are after?

answered Jan 11, 2021 at 12:54

CodeMantle

1,4362 gold badges18 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1