1 2 3 4 5 6 7
WITH ids(id, sort) AS ( VALUES ('foo', 1), ('bar', 2), ('baz', 3) ) SELECT id FROM ids ORDER BY sort;