Visual recursive queries using CTEs
natejgardner
Neuron, Registered, Neuron 2022, Neuron 2023 Posts: 151 Neuron
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.
Tagged: