Yeah, once you've used CTEs it's impossible to go back. Same with window functions. Good news is that Postgres has great CTE support and it was ahead of MSSQL

Yeah, once you've used CTEs it's impossible to go back. Same with window functions. Good news is that Postgres has great CTE support and it was ahead of MSSQL in window functions last I checked!