How to left join with Arel?

You can use

foo.join(bar, Arel::Nodes::OuterJoin) # outer

Because LEFT JOIN = LEFT OUTER JOIN. Outer is an option. See here