Unable to detect valid SELECT statement

[michael-s-molina]

Bug description

Our query parser is unable to detect the following valid SELECT statement:

WITH my_table AS (
  SELECT
    *
  FROM public.cleaned_sales_data
)
SELECT
  *
FROM my_table

On SQL Lab, it throws Only SELECT statements are allowed against this database.

How to reproduce the bug

1 - Go to SQL Lab and try to execute the query
2 - Check the error message

Screenshots/recordings

Superset version

master / latest-dev

Python version

3.9

Node version

16

Browser

Chrome

Additional context

The error comes from:

superset/superset/sql_parse.py

Line 926 in 0286650

def is_select(self) -> bool:

Checklist

• I have searched Superset docs and Slack and didn't find a solution to my problem.
• I have searched the GitHub issue tracker and didn't find a similar bug report.
• I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

[Habeeb556]

#28145 is related I think, as applying the sql_parse.patch resolved this error for me.