In my app I need a backend query for markets that performs the following tasks:
filter whether this market is already done or not (ended in the past)
filter case-insensitive (ilike) by a term that may be in the name, description, long_description or location of the market
limit the results (or have a pagination/infinite scroll behaviour)
Is there a solution or do I have to use a custom action to fill a page state variable at every input change as well as on page load?
I don't like to use API calls, since they seem to be only parsable to Data Types, but not to my supabase Row Types and I want to use those row types wherever I can, since the type may change and I don't want to edit it all the time. Also I am limited to 2 API calls and have more backend queries that have this issue.
I cannot use a Supabase Query, since my filters are too complex (and may get more complex in the future): Currently I would need to do 1. AND (2. OR 2. OR 2. OR 2.) LIMIT 3.
