How do I name columns in a VALUES clause?

sqlite

Solution

with cte(my_column_alias) as 
  (values (1),(2),(3),(4),(5))
select * from cte;

Problem

For this query in SQLite 3.17.0 : ``` select T.* from (values (1),(2),(3),(4),(5)) as T; ``` there is no name for first column of `T`: 1 2 3 4 5 How do I name/alias the first column of `T`, or refer to it by index?

Original source