Line 324. Want me to post code?
« Reply #30, on September 26th, 2011, 09:09 AM »
I like it provided that it only executes a single query otherwise there's no benefit to using a UNION.
I don't think the syntax needs to change at all (to be honest I'm not sure what else you could do with it anyway) and as for ease of use, I can't see any comparable way of making big queries extensible - it's harder to use than a bare query, until you're used to it, but it's extensible in a way that bare queries aren't.
And since I don't envisage most add-ons having to write them I doubt it'll be a problem, provided there is sufficient documentation and examples of using said setup to extend queries.