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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.