It's also worth to mention the idea of WITH ITERATIVE. This is a proposed SQL syntax extension that allows formulating iterative computations. For many problems

It's also worth to mention the idea of WITH ITERATIVE. This is a proposed SQL syntax extension that allows formulating iterative computations. For many problems (including graph traversals), this makes queries easier to write and execute. > We derive new iterative CTE variants from the simple loop-based, operational semantics of SQL:1999’s WITH RECURSIVE. https://www.cidrdb.org/cidr2023/papers/p14-hirn.pdf https://www.cidrdb.org/cidr2023/papers/p14-hirn.pdf https://www.cidrdb.org/cidr2023/slides/p14-hirn-slides.pdf https://www.cidrdb.org/cidr2023/slides/p14-hirn-slides.pdf https://www.youtube.com/watch?v=ZDtSGAeYKU0 https://www.youtube.com/watch?v=ZDtSGAeYKU0