use case

Let's say I have a list of users and I want to search after the username. Currently I am either forced to have the entire list filtered on the client or I have a procedure that iterates over the entire user list and does manual filtering.

It would be nice to have an out of the box operator for this common task.

changes

I would hope for the operator to be available in reducers / procedures, the query builder and SQL queries

benefit

this would make a common use case easier, lead to better performance and it helps Spacetimedb become more compatible with the complete sql syntax

Requested by @ClemensWon via the SpacetimeDB site.