[Solved] Load average of relationships

[guoyunhe]

I have a Product model and a Review model. Review model look like this:

{
  id: 123,
  userId: 123,
  productId: 123,
  rating: 4.5
}

How could I query and load average rating of a Product?

Update: I found it in the doc:

Product.query().withAggregate('reviews', (query) => {
  query.avg('rating').as('rating');
});