Help for this page
my $cursor = $schema->join ... ], ... );
SELECT ... FROM Foo OUTER JOIN Bar on Bar.foo_id = Foo.foo_id AND Bar.size > 2 WHERE ...