Generating these queries requires something like the SQL outer join and I walked through constructing that query in the column. I got some feedback from readers of that column who use the LINQ ...

If LINQ were smart enough-- and it's pretty smart in other areas, at least-- it'd be feasible to see certain of these operations pushed out to the database server in the SQL.