Visual recursive queries using CTEs

natejgardner

Most SQL databases support Common Table Expression style recursion using the WITH RECURSIVE syntax. This allows subqueries to reference their own names. It would be helpful for visual recipes to be able to perform hierarchical or recursive queries to make this type of data somewhat more manageable.