Select * from VALUES / Using VALUES in SELECT

Very useful when you need to use list of your values in FOR cycle etc.
One column in row:

select * from (values('myValue01'),('myValue02'),('myValue03')) as t(column1)

More columns in row:

select * from (values('myValue01', 1),('myValue02', 2),('myValue03', 3)) as t(column1, id)