To match the semantics of the GraphQL compiler, recursive common table expressions (CTEs) are required. SQL backends are good at pushing predicates down into subqueries and CTEs, however this does not ...