doctrine raw sql nativequery code example

Example: run raw sql with doctrine manager

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