Jira issue originally created by user bburnichon:
It would be nice to have a utility method in \Doctrine\Dbal\Driver\ResultStatement to properly retrieve the result column names.
Currently, we have to rely on somthing like
$columnNames = arraykeys($statement->fetch(\PDO::FETCHASSOC));
Problem: It does not work with empty result-sets, and more checks should be performed to handle these.
With PDO, http://www.php.net/manual/en/pdostatement.getcolumnmeta.php could be used to properly retrieve names.
For Sqlite3 it is easy, http://www.php.net/manual/en/sqlite3result.columnname.php
For Mysql, http://www.php.net/manual/en/mysqli-result.fetch-fields.php would do the trick
We cannot change this in 2.x as this would require an interface change. Scheduling this to be discussed for 3.0.