Query builder - is it possible to test it?

query-builder.php

<?php

namespace App\Repositories;

use DB

class MyRepository
{

    public function getAllAmountsByProduct(array $revenueTable, $sRevColumns, $sCompanyID)
    {
        $firstTable = 'rev_rec_' . $revenueTable[0];

        $queryBuilder = DB::table("$firstTable")
            ->join('deal_product', 'deal_product.id', '=', "$firstTable.deal_product_id")
            ->join('products', "deal_product.product_id", '=', 'products.id');

        for ($i = 1; $i < count($revenueTable); $i++) {
            $queryBuilder->join("rev_rec_$revenueTable[$i]", "$firstTable.id", '=', "rev_rec_$revenueTable[$i]" . '.id');
        }

        $queryBuilder->select(DB::raw("products.id, products.name, $sRevColumns"))
            ->where("$firstTable.co_id", '=', $sCompanyID)
            ->groupBy('products.id');

        return $queryBuilder->get();
    }
}