Many applications have the evil feature that asks programmers to create a "Query tool" to allow end users (who don't know SQL or the exact schema of the DB) to create their own queries to look up ...

Queries are the database equivalent of filters in a spreadsheet. Just as a filter can limit and reorganize the information displayed in a spreadsheet, so a query limits and reorganizes the information ...