Advanced Sorting, Filtering and Pagination Help

❔Advice

I'm implementing the search functionality for a table in my database, and because of Convex DB's lack of advanced filtering/sorting, I'm sort of forced to .collect() the entire indexed table into memory and do the filtering/sorting via JS. Because of this also, I must do pagination in memory as I can't get the next set of results without doing all the filtering/sorting.

Does anyone have any advice for this specific use case?