[Doctrine] Come tradurre questa query

[x3d0]

$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