Add ability to create "LIKE" conditions on model text fields

Skuid currently supports =, !=, >, <, >=, <=, starts with, ends with, contains, does not contain, does not start with, and does not end with.

However, you can perform a SOQL query with LIKE, just not in Skuid. Let's add it to Skuid.

Use case:

I have a current use case where I want to be able to map all of our Contacts and Accounts in Skuid. As a part of clean-up, I need to find all US and Canadian constituent records where MailingState/ BillingState field is not using the 2-character state/ province abbreviation. I can do an automated clean-up, but in many cases, someone has pasted the zip or city into this field and I need a human to review it, hence the Skuid page.

I can run a SOQL query using the LIKE syntax to find all of the US/ CA Contacts where the length of the MailingState field is > 2 like this:

SELECT Id, Name, MailingState FROM Contact WHERE (MailingCountry = 'US' OR MailingCountry = 'United States of America' OR MailingCountry = 'United States' OR MailingCountry = 'Canada') AND MailingState LIKE '___%'

(Unfortunately, SalesForce doesn't allow a length formula, but someone had the clever idea to use LIKE and as many underscore characters as needed to build the length.)

I'd love to be able to do this in Skuid. My workaround is to create a temporary formula field in SalesForce and query that in Skuid, but I'd rather be able to keep everything in Skuid without having to remember to delete the field.