Ability to make ActiveRecord joins to root, parent, etc

[vovimayhem]

I've been working on a project that uses this gem, and I'm frequently finding myself wanting to query with joins to root using ActiveRecord's joins with root... however, since root isn't a proper ActiveRecord relationship, that's not possible.

Also, having a family relationship as well, to bring up all the nodes belonging to the tree :)

@sjke Is this something you'd be interested in? I can gladly take a good try at this, I've already got a plan 😈 and might get some code ready as well.

[sjke]

This is a very interesting idea and I think this functionality will be useful. Could you share your ideas/code?