Support table aliases on associated relations

[cllns]

I discovered this bug the other week. If you call join with a relation object, table_alias doesn't work at all. It only works with the name a symbol.

Note this is a PR against release-3.6, not main.

Each commit fixes a different situations, so I recommend viewing each commit separately.