aggregation-queries-hasura-vs-neo4j-graphql

aggregation-queries-hasura-vs-neo4j-graphql.md

Aggregation Queries Hasura vs Neo4j GraphQL

Comparing the queries here.

Fetch aggregated data of an object

Hasura

query {
    articles_aggregate {
        aggregate {
            count
            sum {
                rating
            }
            avg {
                rating
            }
            max {
                rating
            }
        }
        nodes {
            id
            title
            rating
        }
    }
}

Neo4j GraphQL

query {
    articlesAggregate {
        count
        rating {
            average
            max
            sum ## Missing
        }
    }
    articles {
        id
        title
        rating
    }
}

Fetch aggregated data on nested objects

Hasura

query {
    authors(where: { id: { _eq: 1 } }) {
        id
        name
        articles_aggregate {
            aggregate {
                count
                avg {
                    rating
                }
                max {
                    rating
                }
            }
            nodes {
                id
                title
                rating
            }
        }
    }
}

Neo4j GraphQL

query {
    authors(where: { id: 1 }) {
        id
        name
        articlesAggregate {
            count
            rating {
                average
                max
            }
        }
        articles {
            id
            title
            rating
        }
    }
}