How do I formulate a query using the Symfony Plugin DbFinderPlugin to count grouped by columns?

Question

I cannot figure out how to write the following query using the DbFinderPlugin 1.2.2 with Symfony and Propel:

SELECT species, COUNT(*) FROM Bird GROUP BY species;

Here is the DbFinderPlugin page

I am rather new to the plugin, and I do love it so far, but this query has so far stumped me.

Answer 1

I'm not an expert at DBFinder but it looks like the following should work

$result = DbFinder::from('Bird')->
  groupBy('species')-> 
  select(array('species', 'count(*) cnt'))->
  find();

Edited to change code

Answer 2

It turns out that you have to use withColumn to get the proper result:

$result = DbFinder::from('Bird')
    ->withColumn('count(Bird.Id)', 'total_birds')
    ->groupBy(species')
    ->find();