Here is an example of how I solved a database error problem. This was done ten years ago on a Linux box, so L & F is quite motivated, but shows a general concept:

(source: clearlight.com )
This works pretty much as you expect. You can change โANY of the followingโ to โALL of the following,โ and the labels on the following lines change from โorโ to โandโ. The "IS" button can be changed to "IS NOT", as well as to the "Matches pattern" and some other options.
You press the + / - buttons to add additional criteria. You can create logical groups that allow you to make expressions such as "a or (b and c)," but they almost read like a set of English sentences.
In your case, instead of the "Order by" section, you may have a "do these things" section.
This would be inconvenient to use if you need to create very complex queries, but if you need a complex query, you are probably smart enough not to need such a graphical interface. It was designed more for the average user for simple special requests.
I would definitely change the way it looks if I had to do it again, but the basic mechanics work pretty well.
Bryan oakley
source share