[paulddraper]

A right join is simply a commuted left join, so barring some bizzare DMBS optimizer oddity, there's no nothing you couldn't trivially replace with left join or vice versa.

I just checked some code, saw 357 left joins and 1 right join.

    SELECT p.password, u.id
    FROM password p
      RIGHT JOIN "user" u ON p.user_id = u.id