Dereferencing foreign keys / automating joins

Suppose you've got a posts table with a uid foreign key into the users table.
Wouldn't it be nice if you could say
select *, uid->name, uid->avatar from posts
instead of
select p.*, u.name, u.avatar from posts p left join users u using (uid) ?

It'd save typing a lot of joins and significantly simplifies writing and reading queries.

Note the syntax isn't the important part, I simply used the C way of dereferencing a pointer.