A very good example of how the Apex Repository can be used for doing QA-work on your Apex development can be found here.
You can find there such a UNION’ed select — I talked about in one of my previous posts – showing how you can detect all the components where a condition is set to ‘Never’.
Very interesting …