Assuming you want to add a counting column like "numberoffoo" but you want to use your propel environment. Propel, of course, provides a way how you can achive this.
$criteria = new Criteria();
' . FooPeer::TABLE_NAME . '
' . FooPeer::BAR_ID . ' = ' . BarPeer::ID . '); )
"Quelle surprise", propel can deal with that also in the cooler query way.
$result = BarQuery::create()->addAsColumn(
' . FooPeer::TABLENAME . '
' . FooPeer::BARID . ' = ' . BarPeer::ID . ');