R-strings

R-strings handle escape characters without special treatment:

PRQL

from artists
derive normal_string =  "\\\t"   #  two characters - \ and tab (\t)
derive raw_string    = r"\\\t"   # four characters - \, \, \, and t

SQL

SELECT
  *,
  '\    ' AS normal_string,
  '\\\t' AS raw_string
FROM
  artists