select sqlite_version();

CREATE TABLE some_table ( id INT NOT NULL PRIMARY KEY, filler TEXT NOT NULL );

INSERT INTO some_table VALUES (1, '1_val'), (2, '2_val'), (3, '3_val'), (4, '4_val'), (5, '5_val'), (6, '6_val'), (7, '7_val'), (8, '8_val'), (9, '9_val'), (10, '10_val');

SELECT ROW_NUMBER() OVER () AS rn, * FROM (VALUES (5), (7), (1));

SELECT st.id, st.filler, tab.rn, tab.column1, tab.column2 FROM some_table st JOIN ( SELECT ROW_NUMBER() OVER () AS rn, x.column1, x.column2 FROM (VALUES (1, 5), (2, 7), (3, 1)) AS x ) AS tab ON st.id = tab.column2 ORDER BY tab.column1;

-- -- be nice to have FROM (VALUES (1, 5), (2, 7), (3, 1)) AS x (my_col_alia_1, my_col_alias_2) --