[GitHub] rumbin opened a new issue #3998: [SQLLab] Allow common table expressions (CTE), a.k.a. "with" statements

[GitBox <gi...@apache.org>]

rumbin opened a new issue #3998: [SQLLab] Allow common table expressions (CTE), a.k.a. "with" statements
URL: https://github.com/apache/incubator-superset/issues/3998
 
 
   Make sure these boxes are checked before submitting your issue - thank you!
   
   - [x] I have checked the superset logs for python stacktraces and included it here as text if any
   - [x] I have reproduced the issue with at least the latest released version of superset
   - [x] I have checked the issue tracker for the same issue and I haven't found one similar
   
   
   ### Superset version
   0.20.6
   
   ### Expected results
   CTEs can be used within SQLLab
   
   ### Actual results
   `Only 'SELECT' statements are allowed against this database`
   
   ### Steps to reproduce
   Run the following query in SQLLab (here: PogtgreSQL syntax):
   
   ```
   with common_table as (
   	select 1 as mycol
   )
   select
   	*
   from common_table
   ```
   
   ### Analysis of the issue
   * https://github.com/apache/incubator-superset/blob/ac577806071c415eda071aad466322e37eb5b81b/superset/sql_lab.py#L142
   * https://github.com/apache/incubator-superset/blob/f10395b2f755479f2f4b7b359feb80a2ba7e44b4/superset/sql_parse.py#L34
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services