Agregate function returning null instead of 0

[Vishwas-verma]

Query

    return Driver.query()
      .preload("user")
      .where("status", "approved")
      .withAggregate("bookings", query => {
        query.sum("actual_fare").as("total_amount").where("status", "completed");
      })
      .withAggregate("bookings", query => {
        query.sum("driver_wage").as("total_wage").where("status", "completed");
      });

Response

driver.$extras.total_amount = null , useCase is that it should return 0;

Hye ,the agregate sum function is returning null instead of 0 when there is no data what to do so that it return 0,

Also ,I want a suggestion in this discussion #2832 .

[thetutlage]

What happens when you run the same SQL query directly (outside of your AdonisJS app)