Abstract config and reuse connection?

[rsmolkin]

Hi, I'm just starting to get my feet wet with Node.js. I'm looking for a way to connect to and use SQL Server similar to how CFQUERY works in ColdFusion.

I'd like to abstract out the SQL Server database login credentials out to a config setting saved on the server, but not necessarily available to all developers. They should be able to query the DB but they don't need to know the creds.

Also, is it necessary to open and close a connection for every query in an app? Or is it possible to leave the connection open and have multiple queries run over the same connection? In ColdFusion it was a server setting, and most queries would run over the same connection that would just stay open.