Doctrine dql select as with spaces

Question

I would like to know if it's possible to alias a column name with spaces in for example

$query = "SELECT u.firstName AS 'First Name' FROM User u";
$result = $query->getResult( Query::HYDRATE_ARRAY );

Predecease

I don't think this is possible using doctrine DQL, your chance perhaps is to get a PDO instance and write a native SQL query which must support what you want. – Fiji

I have managed to get this working using native query and using the result mapping class, but obviously doesn't use my soft delete filter for example, so hence why having to use dql – Predecease

Have you tried using back ticks `First Name`? Doubt if it will work but maybe. – Town

Yes I've tried that already – Predecease