puresql-mssql-example.js

const mssql = require("mssql")
const puresql = require("puresql")

// Load our queries
const queries = puresql.loadQueries("user.sql")

// Create a connection the adapter will use
mssql.connect('mssql://user:password@host/database')
.then(() => {
  // Create the adapter
  const adapter = puresql.adapters.mssql(mssql)
  // Do something
  async function foo() {
    const rows = await queries.get({}, adapter)
    rows.map(row => {
      console.log('UserId: ' + row.UserId)
    })
  }
  foo()
})