A visual Query Builder can be used to filter data, and you can also enter custom SQL commands for advanced record selection, multiple table joins and other options.

We needed to pull data out of an SQL database, and the query we needed to pull out data was a complex query with multiple table joins, complex filter criteria, and sophisticated WHERE clauses.