Non sargability easy to solve with expression indexes. At least in sqlite.