Secondary sort for dynamic lists

It’d be great to have a secondary (and tertiary, etc.) sorts in dynamic lists. Use cases include:

Job boards: primarily sort by “featured” (true/false), then by time created.

Staff directories: primarily sort by department, then by seniority.

Customer support tickets: primarily sort by status (open/in progress/resolved), secondary sort by priority, tertiary sort by date submitted or time since last update