[I] CTEs (`WITH` clauses) in `UPDATE`, `DELETE` and `INSERT` statements [datafusion-sqlparser-rs]

["lovasoa (via GitHub)" <gi...@apache.org>]

lovasoa opened a new issue, #1763:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/1763

   SQLite, Postgres, and Mssql support WITH clauses attached to data-modifying expressions.
   
   ```sql
   with x(y) as (select 1) UPDATE demo SET Name = 'j'; 
   ```
   
   ```sql
   with x(y) as (select 1) delete from demo; 
   ```
   
   ```sql
   with x(y) as (select 1) INSERT INTO demo VALUES(1,'v','h');
   ```
   
   However, sqlparser cannot parse these.
   
   Initially reported in https://github.com/sqlpage/SQLPage/discussions/852


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org

Re: [I] CTEs (`WITH` clauses) in `DELETE` statements [datafusion-sqlparser-rs]

["iffyio (via GitHub)" <gi...@apache.org>]

iffyio closed issue #1763: CTEs (`WITH` clauses) in `DELETE`  statements
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/1763


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org