How do you connect and query a remote MS SQL Server with Nodejs?

Hello, I am looking for simple code that shows how to connect to a MS SQL Server using nodejs. Everything I have found is overly complicated.
I want code that shows how to connect to the server. It's remote.
Also run a simple query. Querying one row.

The code below is what we were using to just connect to a local Access Database.
I need it modified to connect to MS SQL Server.
Thanks.

describe('test db connection', function () {
  it('tests db connection', function () {      
                var ADODB = require('node-adodb');
                var connection = ADODB.open('Provider=Microsoft.ACE.OLEDB.12.0;Data Source=CDPDB.accdb;');
                connection
                  .query("Select @@Version")
                  .then(data => {
                                console.log(JSON.stringify(data, null, 2));
                  })
                  .catch(error => {
                                console.error(error);
                  });
   browser.sleep(5000);
});
});