Hi.
It is possible to do CTE table query with ROM SQL or we have to handle it at the Sequel level?
I didn’t find anything on the source code of the gem so I am asking.
And if no, what would be the steps to implement it?
Is on the fly relations possible?
Example of what I want to build :
WITH RECURSIVE hierarchical_cte (level_id, parent_id, level) AS
(
SELECT hierarchical.level_id, hierarchical.parent_id, hierarchical.level
FROM hierarchical
WHERE hierarchical.level_id = '1_1_2'
UNION ALL
SELECT hierarchical.level_id, hierarchical.parent_id, hierarchical.level
FROM hierarchical_cte
JOIN hierarchical ON hierarchical_cte.parent_id = hierarchical.level_id
) SELECT * FROM hierarchical_cte;