[web2py] Found correct SQL for left joins with is_active; can dal emit this query?

[Cliff Kachinske]

Works with Postgres.  Not sure about other rdbms.

The query should look like this:

SELECT parent_table.some_field, child_table.other_field FROM parent_table 
LEFT JOIN child_table ON child_table.parent_id = parent_table.id AND 
child_table.is_active = 'T'
WHERE parent_table.is_active = 'T';

I am not aware of any way to cause the dal to emit this query.  Is it 
possible?

--