FROM
my_table
from my_table
select x = 'hello world'
SELECT
'hello world' AS x
FROM
my_table
To quote a string containing quotes, either use the “other” type of quote, or use 3, 4, 5 or 6 quotes, and close with the same number.
'"hello world"' AS x
FROM
my_table
from my_table
select x = """I said "hello world"!"""
'I said "hello world"!' AS x
FROM
my_table
'I said """hello world"""!' AS x
FROM
my_table
from my_table
select x = "\t\tline ends here\n \\ "
SELECT
' line ends here
\ ' AS x
FROM
These special case strings can be used to:
- Insert SQL statements directly into the query. Use when PRQL doesn’t have an equivalent facility.
Currently PRQL allows multiline strings with either a single character or multiple character quotes. This may change for strings using a single character quote in future versions.