Aggregation/GroupBy queries in Datastore

[pcanas]

Before opening, please confirm:

• [X] I have searched for duplicate or closed issues and discussions.

Language and Async Model

Not applicable

Amplify Categories

GraphQL API, DataStore

Gradle script dependencies

// Put output below this line

Environment information

# Put output below this line

Please include any relevant guides or documentation you're referencing

No response

Describe the feature request

Data aggregation is a very common use case (e.g. giving totals, average values over time, aggregated metrics...).

Is this a feature under development or with a publicly known roadmap? What would the current workarounds for this feature be?

Initialization steps (if applicable)

No response

Code Snippet

// Put your code below this line.

amplifyconfiguration.json

No response

GraphQL Schema

// Put your schema below this line

Additional information and screenshots

No response