Skip to content

[FORMATTING] BigQuery: Doesn't handle escaped quotes in raw strings #762

Open
@akshetpandey

Description

@akshetpandey

Input data
Reproduces on https://sql-formatter-org.github.io/sql-formatter/

Which SQL and options did you provide as input?
Language: BigQuery

SELECT
    regexp_extract(event_properties, r'Email": \'(.*?@.*?)\'')
FROM test

Actual Output

Parse error: Unexpected "@.*?)\'') " at line 2 column 50. SQL dialect used: "bigquery".

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions