Repository navigation
GROUP BY, HAVING and aggregation functions support #266
Description
Describe the solution you'd like
GROUP BY, HAVING and aggregation functions (such as count, avg, max and so on) support in queries. It could be very useful for making queries like this:
# Select all users with votes and count votes for each user
select user.id, count(vote.id) as votes_count
from user
left join vote on user.id = vote.user
group by user.id
having votes_count > 0;Before ormar I used to use peewee and I really like a way how it implemented there.
I think it could be easily implemented for queries returning raw values. But it could be a problem with dynamic assigning of Pydantic model fields.
Activity
collerek commentedon Jul 7, 2021
There are related queries for functions and subqueries in #242 and #227.
That seems like a nice feature, but as you wrote that might be challenging to properly parse to pydantic fields.
JAKE4545 commentedon Nov 12, 2021
I met this question now, but I have no idea to solve it.
lewoudar commentedon Jul 26, 2022
Hi folks, sorry to bring this up, but do we have any visibility on its development?
Phizilion commentedon Mar 5, 2024
Need it