[SNOW-1541096] Remove old cte query generation implementation

[SNOW-1541096] Remove old cte query generation implementation #13482