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
Merge pull request #2418 from AD7six/3.0-rename-pivot

rename pivot to junction