It sounds like what you want is SQL. There is no good solution for the cultural problem that a written language is somehow unsuitable for end users. but person

It sounds like what you want is SQL. There is no good solution for the cultural problem that a written language is somehow unsuitable for end users. but personally I have spent way too many hours trying to make a search interface only to realize at the end that not only is my interface complicated and hard to use it still has only a fraction of the descriptive power a sql query has. At times I am tempted to make full use of the built in database permissions and let the user just type queries directly. but this suggestion is always vetoed.