I'm trying to get data from Postgres by using Bookshelf.js. I'm not found a way to do that for Bookshelf.js or execute raw query.

try {
    avgDays = await new User().query((qb) => {
        return "SELECT AVG(date_part) FROM (SELECT DATE_PART('day', disable_account - created_at) FROM users WHERE disabled_account IS NOT NULL) AS date_part"
    }).fetchAll().then(function(data) {
        return data.toJSON()
    }, function(err){
        console.error(err)
    });
} catch (err) {
    throw err;
}

This code return all rows from table. Please help to convert SQL to Bookshelf.js. Thanks.