R-strings handle escape characters without special treatment:
from artists derive normal_string = "\\\t" # two characters - \ and tab (\t) derive raw_string = r"\\\t" # four characters - \, \, \, and t
SELECT *, '\ ' AS normal_string, '\\\t' AS raw_string FROM artists