The menu is rendered relatively rarely. Even if we were to go that route, I think the simple solution would be to take what goes into the CTE and materialize i

The menu is rendered relatively rarely. Even if we were to go that route, I think the simple solution would be to take what goes into the CTE and materialize it after menu update. But it's not a lot of nodes and not a lot of depth. Why complicate your data storage model if you don't need to?