After investigating some infrastructure choices for Node.js projects I’ve finally decided to take a look at Sails.js - a neat little Rails-like MVC for Node. Its actually pretty interesting in version 0.9, but was missing some critical features - namely Associations/Relationships.
However, the Sails team is nearing completion on version 0.10 of Sails which has a fairly robust implementation of Associations via Waterline. But to check this out, you have to remove your existing version of sails:
sudo npm uninstall sails
and then install the version 0.10 branch:
sudo npm install sails@git://github.com/balderdashy/sails#v0.10 -g
From there you should be good to go to explore the way it handles associations.