test.js

var getStData = function() {

  // loading database from db.js
  var connection = dbConnect.shoreware();

  //SQL Query
  connection.query('SELECT u.UserDN, GuiLoginName, LDAPGuid, LDAPDomainName, EmailAddress, s.FirstName, s.LastName, s.WorkPhone, s.CellPhone, s.FaxPhone, s.SiteName, d.Digits, CONCAT(SUBSTR(BasePhoneNumber,3,10 - CHAR_LENGTH(d.Digits)),d.Digits) AS DID FROM shoreware.users AS u JOIN shoreware.diddigitmap AS d ON  u.UserDN = d.DN  JOIN systemdirectorydisplay AS s ON u.UserDN = s.dn JOIN tabaddresses AS t ON s.WorkPhone = t.WorkPhone WHERE LDAPUser = 1', function getStSqlData(err, res) {
    if (err) throw err;

    // parse response from sql query
    var stJsonString = JSON.stringify(res);
    var stJsonData = JSON.parse(stJsonString);

    //if stJsonData is not defined, throw an error
    if (!stJsonData) throw 'err: stJsonData is not defined'
    
    return stJsonData;
  });
};

var printStData = function(data) {
  data.forEach(function (element, i) {
    console.log(element);
  })
}

printStData(getStData())