The best replacement for cte is temp table.

The best alternatives to cte are rated as following:
★★★★★  temp table
★★★★  var
★★★★  subquery
★★★  brick squad
★★  temp tables
★★  cursor
★★  derived table
★★  mre
★  temp
★  table variable
★  alzheimer's
★  aga
★  so icey
  dj drama
  subselect
  bmf
  outer apply
  tbi
  mmg
  grand hustle

Your alternative for cte is not listed? Suggest!
Speaking about cte, one probably shouldn't forget about insert.

Other search terms related to cte and their ratings are:
★★★★★ insert
★★★★ merge
★★★ sql
★★★ dynamic sql
★★★ row_number
★★★ update statement
★ union all
★ sql server
★ recursion
★ example in sql server
You have in mind a companion for cte and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of cte in all years. Click on graph for more.
cte
temp table
var