Select constant text that is the same as a column name
Values in SQLite should be wrapped in single-quotes, like:

INSERT INTO Table1 (a, b, c) 
SELECT 'a', a, b 
FROM Table2;


However, as @Ypercube asked in his comment, why do you want a column with the same value for every row?