WITH statements seem convinient. But nested recursive SQL statements / subqueries can be an performance issue. Sometimes speed is more important than a SQL99 or

WITH statements seem convinient. But nested recursive SQL statements / subqueries can be an performance issue. Sometimes speed is more important than a SQL99 or SQL2003 feature, some implementations are fast with SQL89/92 syntax.