Add a subquery as where clause to your propel criteria or statement?
So you are still using the propel - the blazing fast php orm but you want to narrow/scope your result by a complex/not daily condition?
No problem you can use a subquery and put it to the where condition area.
$mySubqueryForFoo = '(
' . FooPeer::TABLE_NAME . '
' . FooPeer::BAR_ID . ' = ' . BarPeer::ID . '
) > 0';
//if you are using the criteria object
//if you are using the query object