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.