Hello, I've produced a dumb patch for psql which allow to use tab completion after JOIN keyword. Patch was done against 2f6c8453cf3f38a70adbcb59489630cd5be92570 revision from GitHub mirror.
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных