Document use of union/intersect/except in SQL queries
We should improve documentation on the use of union/intersect/except SQL set operators as a follow up to !39786 (merged)
There is at least one mention in the docs. Going forward I think these set operators will find quite a bit of use. It will be good to state clearly the motivations and purpose of why we code in this way.
cc @Alexand