I'm still not convinced after my previous question and some experience.

Requirements:

I don't want to use an SQL query everytime a filterBy() function is called and still be able to call ->filterBy() on the returned table.

Please find the comment @ ObjectsTable class: "How to instantiate another table and add records which match the filter criteria?"

Usage:

$globaltable = new ObjectsTable(); //globally accessible variable
$globaltable->findAll(); //this call is made once at the beginning of the request

$globaltable->filterBy('somefield', $someValue); //this function is used all over the place

ObjectsTable class:

class ObjectsTable extends Doctrine_Table {
    function filterBy($field, $value) {
        //How to instantiate another table and add records which match the criteria?
    }
}