Thinking about it more, we may want to have a completely separate clause that explains the weird thing we are doing by constructing two tables -- one that has the "correct" data and then another with all of the zero'd/NULL'd columns that we join with a `UNION`.