As other posters have pointed out, you can overcome the ORDER BY/LIMIT restriction on UNIONs with parentheses. I think
Imisbalanced the parentheses in my original post, which would have caused an error if you just copied and pasted.
I don't think the limitation has to do with planning--just parsing the query.
