How to implement server-side search logic?

A traditional straightforward solution would be to use WHERE name LIKE '%{}%', but SpacetimeDB's SQL dialect doesn't support LIKE.

The native approach seems like calling a reducer implementing the (perhaps, complex) search logic, but we can't return any data from reducers (unless we abuse Err responses, which I used once to return a String, but putting JSON there would be a crime).

The only actual solution now is to use a reducer paired with a volatile results table, but this seems cumbersome, counterproductive and pretty inefficient (have to store the entire thing).

Is there another way to it? If not, it's a feature request (might be as general as implementing reducer results).