You can just create a view for each table with all other useful tables joined and query that.

It would indeed be nice to do that automatically based on foreign keys; I suppose one could write a PostgreSQL extension for that (or maybe one exists?).

Of course you still need the ability to perform joins that are not implied by the database structure.