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