[GENERAL] Transitive Closure and CONNECT BY

[Robert James]

Is there a transitive closure (or equivalent) operator in Postgres (or
extension)?
Anything like CONNECT BY?
Or any recommended way of querying hiearchial data?