I would go one step further and make the join just JOIN Bar b if you've defined the foreign keys before. The need to spell them out again and again is one

I would go one step further and make the join just JOIN Bar b if you've defined the foreign keys before. The need to spell them out again and again is one of my personal SQL pet peeves.