This comes in handy as Doctrine doesn’t always support all native MySQL commands and functions. Strangely, certain common time and date-related ones like YEAR(), MONTH() and DAY().
The $paramsArr is an array for all placeholders in your standard PDO query.
// Symfony raw queries with placeholders.
// Example query:
$query = "SELECT * FROM users WHERE status=:status
GROUP BY last_name ORDER BY last_name ASC";
$stmt = $this->em->getConnection()->prepare($query);