title: CakePHP - Column aliases in SQL queries
body: <p>Is there a good way to specify column aliases when performing find() operations on a model?</p>
  
  <pre><code>$this-&gt;User-&gt;find('first', array(
      'fields' =&gt; array(
          'CONCAT(firstname, ' ', surname) AS fullname',
          'email',
          'tel'
      )
  );
  </code></pre>
  
  <p>At the moment, if I do it like this it returns the data like this:</p>
  
  <pre><code>Array
  (
      [0] =&gt; Array
          (
              [fullname] =&gt; John Smith
          )
  
      [User] =&gt; Array
          (
              [email] =&gt; jsmith@example.com
              [tel] =&gt; 0123456789
          )
  
  )
  </code></pre>
  
  <p>Is there a way to have it return the column aliases like normal columns?</p>
  
  <pre><code>Array
  (
      [User] =&gt; Array
          (
              [fullname] =&gt; John Smith
              [email] =&gt; jsmith@example.com
              [tel] =&gt; 0123456789
          )
  
  )
  </code></pre>