Oracle Hierarchical Queries (START WITH ... CONNECT BY ...) are great for selecting tree-like views using single SQL query and still be able to sort them as intended. Things are getting complicated when We trying to use them in framework Query Builder, like this one in Yii 2.
Oracle hierarchical queries in Yii 2 Query
O