CODE EXAMPLE FOR PHP

run raw sql with doctrine manager

   $em = $this->getDoctrine()->getManager();
   $stmt = $em->getConnection()->prepare($sql);
   $stmt->execute();
   return $stmt->fetchAll();