use Database.raw in from method of query builder

[farshadfahimi]

I have a query like below and need to use the Database.raw in the from mthod but in the build got error about this query.

How should I resolve ts build error and compile my code without and build error

public async bestSellerProducts() {
    return await Product.query()
      .from(
        Database.raw(`(
          SELECT products.id, 
              @product_rank := IF(@current_brand = products.brands_id, @product_rank + 1, 1) AS product_rank,
              @current_brand := products.brands_id 
          FROM ( 
              SELECT
                  products.*,
                  SUM(orders_products.qty) AS sold
              FROM products
              RIGHT JOIN orders_products ON orders_products.products_id = products.id
              LEFT JOIN orders ON orders.id = orders_products.orders_id
                  where products.is_published = 1
                  AND products.stock_count > 0
                  AND products.categories_id IN(${this.relatedIds})
                  ${Application.inProduction ? 'AND started_at <= now() and ended_at >= now()' : ''}
              GROUP BY products.id, products.brands_id
              ORDER BY products.brands_id, sold DESC
          ) products
        ) as products`)
      )
      .where('product_rank', '<=', 3)
      .orderBy('sold', 'desc')
      .preload('productPrice')
      .preload('productOffer')
      .preload('defaultMedia')
      .limit(15)
  }

[LiegeoisJules]

I think you can add a @ts-ignore on the line before your function bestSellerProducts()