Is it possible to sort by several criteria at the same time?

Question

Database

More specifically: there is a database in which the data lies. There is a frontend that displays a selection. At the same time, users can change the sort order, apply filters, and perform other similar actions with the selection. The question arose: is there a ready-made solution for the database server to return a data set sorted by several possible criteria at once? I.e., something like that the server would return a set of data, as well as sets of keys, sorted into several possible options? In order not to re-sort at the front, but to take a ready-made sequence. Or is it necessary to execute the ORDER BY query several times and return the resulting key sets?