R-strings

R-strings handle escape characters without special treatment:

PRQL

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

SQL

1. SELECT
2. *,
3. '\    ' AS normal_string,
4. '\\\t' AS raw_string
5. FROM
6. artists