I went back and forth between psql and pgcli for several years, until I realized that pgcli tab-completes JOIN conditions.
SELECT *
FROM parent
JOIN child USING (user_id)
I personally think naming your primary keys with their full name instead of calling all of them `id` or `key` is better practice also.