Using a literal string in SELECT statement
Unfortunately, we can't provide a literal string. SOQL only accepts fields and a few select formulas in the fields section of a query. This includes aggregate functions (COUNT, MAX, MIN), toLabel, and TYPEOF (in some cases). If you wanted to include a literal value, you'd have to make a formula and select it as a field.