Skip to content

Escape character issue in s-strings #5496

@priithaamer

Description

@priithaamer

What happened?

This used to work in 0.13.4

PRQL input

let outputs_sql = (
  from s"
    select 'a' as \"col1 foo\", 'b' as \"col2#bar\"
  "
)

from outputs_sql
select {
  `col1 foo` = outputs_sql.`col1 foo`,
  `col2#bar` = outputs_sql.`col2#bar`
}

SQL output

⎿  Error: Error:
        ╭─[ :3:29 ]
        │
      3select 'a' as \"col1 foo\", 'b' as \"col2#bar\"
        │                             ┬
        │                             ╰── unexpected '\'
     ───╯

Expected SQL output

WITH table_0 AS (
  SELECT
    'a' as "col1 foo",
    'b' as "col2#bar"
),
outputs_sql AS (
  SELECT
    *
  FROM
    table_0
)
SELECT
  "col1 foo",
  "col2#bar"
FROM
  outputs_sql

MVCE confirmation

  • Minimal example
  • New issue

Anything else?

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugInvalid compiler output or panic

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions