Where is the LIKE predicate?
The LIKE predicate for string matching is still not supported at the SQL level. For what it’s worth, it is easy to use Python’s string matching (regex, re, string.search, etcetera) facilities on the result of a query. Also, for what it’s worth, since the gadfly optimizer won’t easily be able to optimize for string matching the “by hand” method would essentially be what gadfly would do anyway, without major modifications to the implementation.