We use node-sqlserver (https://github.com/WindowsAzure/node-sqlserver).

We also give scripts full access to the node-sqlserver driver, so they can run their own arbitrary SQL as necessary.