Using PDO from the DB facade for a complex query

example.php

$sql = "SELECT tblSU.Site, 
    tlkpSUDesc.ESR_SUcat, 
    tlkpSUDesc.ESR_SUcatdisp, 
    tlkpSUDesc.SUDesc, 
    tlkpSUTyp.SUTyp, 
    tblSU.SUNum 
    FROM tlkpSUTyp 
    RIGHT JOIN (tlkpSUDesc RIGHT JOIN tblSU ON tlkpSUDesc.SUDescCode = tblSU.SUDescCode) 
    ON tlkpSUTyp.SUTypCode = tblSU.SUTypCode 
    WHERE tblSU.Site = :id 
    AND tlkpSUDesc.ESR_SUcat = :category 
    AND tblSU.SUTypCode != 'GEN' 
    ORDER BY tblSU.Site, tlkpSUDesc.ESR_SUcatdisp, tblSU.SUDescCode";
    
$statement = \DB::getPdo()->prepare($sql); 
$statement->setFetchMode(\PDO::FETCH_OBJ); 
$statement->execute([
    'id' => $id, 
    'category' => $category
]); 
$result = collect($statement->fetchAll());