You may be interested in the USING clause SQL-92 added for foreign keys where the referencing columns have the same name as the referenced columns: JOIN b USING (a_id). The only major RDBMS that doesn't support it is SQL Server afaik.
Example:
SELECT
language.name,
COUNT(*)
FROM rental
JOIN customer USING (customer_id)
JOIN address USING (address_id)
JOIN city USING (city_id)
JOIN country USING (country_id)
JOIN inventory USING (inventory_id)
JOIN film USING (film_id)
JOIN language USING (language_id)
WHERE country.country = 'Sweden'
GROUP BY language.name
ALTER TABLE rental ADD address_id integer;
ERROR: common column name "address_id" appears more than once in left table