The only caveat is that all where clause criteria become join criteria if you use DI’s left outer join. If that is not sufficient (ie, if you need some filtering BEFORE the join), you can get the same effect with a pushdown_sql. See my example here:
eepjr24 (BOB member since 2005-09-16)
(BOB member since 2005-09-16)