User Problem

Users want to be able to effectively use a LIKE '%string%' comparator with wildcards in their WHERE clauses. Currently, manually adding the %% wildcards to the LIKE comparator only works when using a hardcoded string. This is not possible when referencing text from a {text_input} control. 

Suggested Solutions

Add a "contains" operator to the pattern match list that effectively adds a LIKE '%string%' comparator. This will allow seamlessly referencing text_input controls in visual SQL

Current Workarounds

Currently, in order to access that functionality, you either need to 
1)explicitly add wildcards in your text input within a text input control.
2)access the raw input  and concatenate the wild cards in SQL mode.