There are many situations where LIKE just doesn't cut it, or is simply too slow.
The most common case is probably when one wants to search for a record that contains all keywords entered in a search box. It would be great if the platform allowed creation of full-text indexes and use of full-text search SQL in Aggregates and Advanced Queries.