Relation Aggregates

Relation aggregates attach related counts or aggregate values to the main query result.

Count and exists

articles, err := db.Use[Article]().
    WithCount(Article{}.Comments()).
    WithExists(Article{}.Cover()).
    Get(ctx)

Aggregate values

articles, err := db.Use[Article]().
    WithSum(Article{}.Comments(), "Score").
    WithAvg(Article{}.Comments(), "Score").
    WithMin(Article{}.Comments(), "CreatedAt").
    WithMax(Article{}.Comments(), "CreatedAt").
    Get(ctx)

Optional callbacks

articles, err := db.Use[Article]().
    WithSum(Article{}.Comments(), "Score", func(q *oro.RelationQuery) {
        q.Where("Status", "approved")
    }).
    Get(ctx)

Callbacks constrain only the relation aggregate query.

Dynamic relation names

articles, err := db.Use[Article]().WithCount("Comments").Get(ctx)

Static relation methods are preferred, but strings are supported for dynamic modules.