Backend FIlter/Sort

[naasanov]

Motivation

Currently we do all table sorting/filtering. While this works for now, it relies on the user's hardware specs and scales badly. We should move to server side sorting/filtering to address this.

Deliverables

• Create a reusable utility in core/ that applies specified pagination, sorting, and filter parameters to a given query
• Modify the get all routes for each relevant module to use this util to handle pagination, sorting, and filtering
  • These features should be opt in with sensible defaults.
• Create/modify tests for the get all routes
  • Extend/create http utils to consolidate logic, and use parameterized tests whenever possible

Important Notes

• Try to be as type safe as possible, but if it gets too hacky plain dicts are fine