what technology exists for joins across many tables in postgres code example

Example: psql join

SELECT *
    FROM weather INNER JOIN cities ON (weather.city = cities.name);