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

Stars is a great ranking technique, e.g.http://www.node-modules.com/search?q=postgresql&u=

I'm using knex [0] which I am pretty happy with. There is also a higher level version built on top of it called bookshelf [1]

0 : https://github.com/tgriesser/knex 1 : https://github.com/tgriesser/bookshelf