Any good example of dynamic querying when you have a lot of options for sorting, filtering, ordering and pagination.

// TODO: Adding Dynamic Filters & Sorting
        // Limit - How many records needed
        // Sort - Listing Date, Public Date, Pre-Sale Date
        // Filter - Mint Price Range, Market Place, Blockchain, Project Type, Categories
        // Defaults - Pubic Sale Asc, 5 Days
        // Pagination - rows, dates

Right now am trying to build multiple where clause to accommodate the above but it doesnt seem to be efficient.

Tell me if you find a solution, also looking for a way to make the filters for my query dynamic so the user can choose on what to filter