I'm a big fan of ORMs in other ecosystems (Rails and Django, for example), but in node I like to write more functional-style code, composing small modules into larger applications.
For this, check out the fantastic node-postgres adapter from brianc as well as his node-sql package for authoring SQL statements.
https://github.com/brianc/node-postgres https://github.com/brianc/node-sql