title: Database agnostic virtual fields in CakePHP
body: <p>In CakePHP 1.3 there is a feature for <a href="http://book.cakephp.org/view/1608/Virtual-fields" rel="nofollow noreferrer">virtual fields</a> but it's coupled with the database that you are using. For example: </p>
  
  <pre><code>var $virtualFields = array(
    'full_name' =&gt; 'CONCAT(User.first_name, " ", User.last_name)'
  );
  </code></pre>
  
  <p>This would work for MySQL but not for MS SqlServer. Is there a way to make this database agnostic?</p>
  
  <p>I'm still in the middle of developing an application and still not sure what database we'll be using in production. That's why I want to keep all the database access as agnostic as possible. </p>