I think it might be useful to add startswith(), endswith() and containsstring() methods to Comparable, implemented with LIKE similar to CONTAINSSTRING(). That would allow more natural usage (e.g. store.find(Table, Table.column.startswith("foo"))).
If Comparable.__contains__() could work for "substring in column" type expressions, then that might be even better (although wouldn't allow for a case_sensitive optional argument).
I think it might be useful to add startswith(), endswith() and containsstring() methods to Comparable, implemented with LIKE similar to CONTAINSSTRING(). That would allow more natural usage (e.g. store.find(Table, Table.column. startswith( "foo")) ).
If Comparable. __contains_ _() could work for "substring in column" type expressions, then that might be even better (although wouldn't allow for a case_sensitive optional argument).