rename pivot to junction

junction is a more familiar alternate name to "join table". The name join cannot/shouldn't be used as the function could easily be confused with a function to join a table into a query, rather than a method for getting/setting the table name/instance for the join table.

closes #2391