I believe you could write it as
knex.select('id', knex.raw('SUM(x.kills)'))
.from(function() {
knex.select('id','kills').from('bedwars_player_solo')
.unionAll(
knex.select('id','kills').from('bedwars_player_duo'),
knex.select('id','kills').from('bedwars_player_comp_clan')
).as('x')
}).groupBy('id')
.orderBy('total', 'desc')
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…