Support for UNION and sub-queries

This is going to be a bit tricky. A UNION is two queries run separately but their results are merged as one before sorting, etc. So the question becomes, where do I want to put this. Is it an extension to the Table class, or is this a new thing?