The Dataiku Frontrunner Awards have launched to recognize your achievements! SUBMIT YOUR ENTRY

Visual recursive queries using CTEs

0 Kudos

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.