Reviewer-facing queue order: priority first, then nearest SLA deadline
(records without one last), then FIFO (createdAt, id). THE definition of
orderBy: 'reviewer' — the dashboard's sortQueue (approval-ui/view-model.ts)
delegates here and d1-store.ts mirrors it in SQL (store.test.ts pins the
cross-backend parity), so a bounded server page and the client-side sort
can never rank differently.
Reviewer-facing queue order: priority first, then nearest SLA deadline (records without one last), then FIFO (createdAt, id). THE definition of orderBy: 'reviewer' — the dashboard's sortQueue (approval-ui/view-model.ts) delegates here and d1-store.ts mirrors it in SQL (store.test.ts pins the cross-backend parity), so a bounded server page and the client-side sort can never rank differently.