Recently while working with Symfony, and mucking about with the sfPropelRouteCollection class I had an action that queried a table with some foreign keys. Which is no big unique thing, and fairly typical. With propel you can get the related objects fairly easy as well which again is nothing ground shaking....