Is there a reason for recursive queries not being the first choice?<p>I had versioning problem to solve recently, and recursive CTE was my first choice (did take some time to wrap my head around but was also performant enough), <a href="https:&#x2F;&#x2F;github.com&#x2F;recipehub&#x2F;recipehub-service&#x2F;blob&#x2F;master&#x2F;data.py#L48" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;recipehub&#x2F;recipehub-service&#x2F;blob&#x2F;master&#x2F;d...</a>