[sql generation] fix missing join with outer joins w/ rhs invariant variable... ... where the principal where not the processed relation. This led to major refactoring in outer join handling, which is now much clearer and powerful. Closes #1579228

# copyright %(year)s %(author)s, all rights reserved.
# contact %(author-web-site)s -- mailto:%(author-email)s
#
%(long-license)s
"""%(distname)s repository side views, usually for notification"""