add a temporary column with a value

You mean staticly define a value, like this:

SELECT field1, 
       field2,
       'example' AS newfield
  FROM TABLE1

This will add a column called "newfield" to the output, and its value will always be "example".

select field1, field2, 'example' as TempField
from table1

This should work across different SQL implementations.

Related