Comment by benilov

DbFit (http://dbfit.github.io/dbfit/) provides a more heavy-weight, but much more scalable alternative to raw SQL for testing CTEs.