Keyboard shortcuts

Press or to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

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