enjoyjava
Express allows you to expose HTTP endpoints as APIs but it doesn't facilitate the quest to build/aggregate/protect/document APIs that interacts with various backend systems, such as DBs, Cloud services, and internal REST/SOAP APIs. LoopBack is positioned to be a fully-fledged API server with SDKs for JS, iOS, and Android.
http://docs.strongloop.com/display/DOC/Model+definition+refe...
http://docs.strongloop.com/display/DOC/Model+definition+refe...
2. We allow you to execute native query using dataSource.connector.query(query, params, cb). We're considering to promote it to dataSource level and fully document it.
PostgreSQL Connector for Loopback: create Node.js powered APIs for Postgres
Restify your SOAP APIs with LoopBack
LoopBack is part of the StrongLoop suite distribution too. That's where you will get an integrated solution (with StrongNode & StrongOps) and commercial supports.