title: Select specific column(s) using Propel without aliasing
body: <p>I'm having quite a bit of trouble rewriting a simple query using methods provided by Propel 1.6.</p>
  
  <p>The query is as follows:</p>
  
  <pre><code>SELECT type_id, COUNT(id) as `count` FROM visit GROUP BY type_id;
  </code></pre>
  
  <p>Using Propel, I've written the following:</p>
  
  <pre><code>$visitCount = VisitQuery::create()
                  -&gt;withColumn('COUNT(id)', 'count')
                  -&gt;groupBy('TypeId')
                  -&gt;find();
  </code></pre>
  
  <p>This generates the following query:</p>
  
  <pre><code>SELECT visit.ID, visit.JOB_ID, visit.ENGINEER_ID,
         visit.TYPE_ID, visit.VISIT_DATE, visit.STATUS, COUNT(id) AS count 
  FROM `visit` 
  GROUP BY visit.TYPE_ID
  </code></pre>
  
  <p>Which works, but <strong>I only need the columns <code>type_id</code> and the <code>count</code></strong>, so I tried adding the following:</p>
  
  <pre><code>$visits = VisitQuery::create()
              -&gt;withColumn('COUNT(id)', 'count')
              -&gt;select(array('TypeId'))
              -&gt;groupBy('TypeId')
              -&gt;find();
  </code></pre>
  
  <p>This generates the following (working) query:</p>
  
  <pre><code>SELECT COUNT(id) AS count, visit.TYPE_ID AS "TypeId" 
  FROM `visit` GROUP BY visit.TYPE_ID
  </code></pre>
  
  <p>However, I don't want to alias the <code>type_id</code> column. I tried passing the actual column name to the <code>select</code> array (<code>-&gt;select(array('type_id'))</code>), however that results in the following query (which obviously doesn't work):</p>
  
  <pre><code>SELECT COUNT(id) AS count,  AS "type_id" FROM `visit` GROUP BY visit.TYPE_ID
  </code></pre>
  
  <p><strong>How can I retrieve the <code>type_id</code> column without it being aliased?</strong></p>