So 

I am reflecting a business logic from on prem to azure databricks . 
what on prem did is 

created the table and after that updated . 
I have to construct that as a single query . 
Example 

Create or replace table table1

with CTE 1 as (

) ,

CTE 2 as (

select some columns from cte1

) , 

CTE 3 as (

select some columns from CTE2

)

select * from CTE3 

but there are some updates from on prem which I need to apply to CTE2 . 
can I apply those updates after CTE2 before CTE 3 ?