CONNECT BY PRIOR equivalent in Trino

[vicks86]

Hi,

Is there any equivalent function/query in Trino for "CONNECT BY PRIOR" / hierarchical query?

Below is the Oracle sql query that I want to migrate into Starburst Trino Version: 370-e.1
SELECT a.CHILD_ID
FROM HRCHY_MV a
CONNECT BY PRIOR CHILD_ID = PARNT_ID
START WITH a.PARNT_ID = 'EXT'

Thanks!

[findepi]

Would WITH RECURSIVE help?
see https://trino.io/docs/current/sql/select.html#with-recursive-clause

[vicks86]

Thanks!
I will check WITH RECURSIVE CTE.