This is perhaps not exactly what the OP was looking for, but I came across this post when searching for a way to temporarily select specified values on-the-fly as table data result in SQL.

See: https://stackoverflow.com/a/7285095/4993856 by pm..

Basically:

SELECT *
FROM (
    VALUES ('a',1), ('b',2), ('c',3) 
) AS X("Column a","Column b")

produces: