Add group_by action method

[RobertCraigie]

https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#groupby

The design decision we need to make here is how to represent the data that prisms returns.

[HKGx]

any updates?

[RobertCraigie]

@HKGx Not yet, although this is not a difficult change. I'll work on it now.

[RobertCraigie]

@HKGx Do you need to also query by _count, _avg, _sum, _min or _max? (https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#groupby)

I forgot about these aggregation fields before mentioning that this is not a difficult change. Adding support for querying by these fields is more difficult due to internal features that I haven't implemented yet. If you don't need these, I can prioritise getting an initial proof of concept implemented which you would be able to use until the next release.

[HKGx]

@RobertCraigie I'd say so as I'm currently doing

SELECT field, COUNT(field) FROM table GROUP BY field

Not sure how it applies to Prisma, though.

[RobertCraigie]

@HKGx You would be correct, I'll see what I can do.

For reference, the missing internal feature is serializing queries for selecting fields (#19).

[RobertCraigie]

@HKGx I've added the initial support for this feature.

You can try it out by installing from the wip/group-by branch:

pip install -U git+https://github.com/RobertCraigie/prisma-client-py@wip/group-by

It should be noted that the group_by method returns a TypedDict, not a BaseModel.

This is also very much a work in progress, please let me know if you encounter any issues.