title: is there an alternative to query with DELETE snowflake SQL statement with CTE?
body: <p>On snowflake, is there an alternative to query with DELETE SQL statement with CTE? seems it is not possible.</p>
  
  <pre><code>with t as (
  select *  from "SNOWFLAKE_SAMPLE_DATA"."TPCDS_SF100TCL"."CALL_CENTER"
  ), p as (select t.CC_REC_END_DATE, t.CC_CALL_CENTER_ID , t.CC_REC_START_DATE from t where 1=1 AND t.CC_REC_START_DATE &gt; '2000-01-01')
  
  delete from p
  </code></pre>
  
  <p>For example: if we use a select, we got some results.
  <a href="https://i.stack.imgur.com/SUdLX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SUdLX.png" alt="CTE with simple SQL select"></a></p>
  
  <p>but if I use a delete. It shows a syntax error</p>
  
  <p><a href="https://i.stack.imgur.com/UjvfH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UjvfH.png" alt="CTE with delete"></a></p>