Support for `aggregate` operations under child tables e.g. `count`

[bossjapzz]

Describe the bug Support for aggregate operations under child tables

Expected behavior

query MyQuery {
  GroupContent_connection(order_by: {GroupContentReactions_aggregate: {count: desc}}) {
    edges {
      node {
        id
        GroupContentReactions_aggregate {
          aggregate {
            count
          }
        }
      }
    }
  }
}

Output

{
  "data": {
    "GroupContent_connection": {
      "edges": [
        {
          "node": {
            "id": "WzEsICJwdWJsaWMiLCAiR3JvdXBDb250ZW50IiwgImNrdHpld24zaTAxNjUwMTNkeHBuZjUzcTQiLCAiY2t1MDExZ2h5NzE4MDAxOHl0cHFhZmF6ZCJd",
            "GroupContentReactions_aggregate": {
              "aggregate": {
                "count": 8
              }
            }
          }
        },
      ]
    }
  }
}    

[github-actions[bot]]

This issue is stale because it has been open for 30 days with no activity.

[jdgamble555]

This would be huge, as it is a needed feature.

J

[mojerro]

is there any roadmap on this issue

[olirice]

The conversation about this feature hasn't happened internally yet but I expect it'll happen with an opt-out option for people concerned about performance.

User defined functions and any spec inconsistencies will be resolved before this gets tackled. Its not on the schedule yet but probably in the next few months