support common table expression with insert/update/delete

We currently have limited our cte support to just query expressions. This should be generalized to more statement types.