my $cursor =
    $schema->join
        ( select => [ $table1, $table2 ],
          join   =>
          [ [ left_outer_join => $table1 => $table2 ],
            [ $table2 => $table3 ],
          ],
          ...
        );

##</code><code>##

  SELECT ... FROM Foo
       OUTER JOIN Bar on Bar.foo_id = Foo.foo_id AND
                  Bar.size > 2
  WHERE ...