It supports any type of filtering you could need. It hides the complexity of what I assume behind the scenes are table joins. It's not for quantitative report

It supports any type of filtering you could need. It hides the complexity of what I assume behind the scenes are table joins. It's not for quantitative reporting but rather for retrieving manageable lists of relevant issues out of a data base of hundreds to hundreds of thousands. What sort of query would you want to run against an issue tracker that you don't see supported there?