rename pivot to junction

junction is a more familiar alternate name to "join table". The name
join cannot/shouldn't be used as it 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