Can't seem to use the LIKE operator with an already existing text column either.
Edit: Perhaps it's related to how quotes are escaped.
This filter:
WHERE UserCity LIKE 'Houston'
produces this error:
Invalid JSON: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Houston\'' at line 1