[Doctrine] Come tradurre questa query

[leonapster]

$sql = "SELECT * FROM packages WHERE least_night<='" . $days_holiday . "' AND
            id_build='". $id_build . "' AND
        (
            ( '" . $date_from . "' >= date_from AND '" . $date_from . "' <= date_to )
         OR ( '" . $date_to . "' > date_from AND '" . $date_to . "' <= date_to )
         OR ('" . $date_from . "'<=date_from AND '" . $date_to . "'>= date_to)

         )
        AND
            (forced=0 OR
                (forced=1 AND
                                date_from='" . $date_from . "' AND
                                date_to='" . $date_to . "'
                 )
             )

         ORDER BY date_from
         "; 

Come la posso tradurre in DQL? Ovvero nel linguaggio specifico per DOctrine ed eseguire