Как простроить сложный запрос без ORM

const result = await pool.query(`
  SELECT users.*, COUNT(orders.id) as order_count 
  FROM users
  LEFT JOIN orders ON users.id = orders.user_id
  WHERE users.status = 'active'
  GROUP BY users.id
  HAVING COUNT(orders.id) > 5
  ORDER BY order_count DESC
`);

const users = await knex('users')
  .select('users.*')
  .count('orders.id as order_count')
  .leftJoin('orders', 'users.id', 'orders.user_id')
  .where('users.status', 'active')
  .groupBy('users.id')
  .having('order_count', '>', 5)
  .orderBy('order_count', 'desc');