title: Javascript nodejs tedious mssql is there a way to get json?
body: <p>I'm using nodejs and tedious connector to get data from mssql server. In documentation, I only see this one way to retrieve data</p>
  
  <pre><code>var request = new Request("select Name, Value, Article_Id from [tableone] where Id = '1'", function (err, rowCount, rows) {
  
      if (err) {
          console.log(err);
      } else {
          console.log(rowCount + ' rows');
      }
  });
  request.on('row', function (rows) {
  
      ...
      bigArrat.push(JSON.stringify(rows));
  });
  </code></pre>
  
  <p>But in my example I want all rows, not only one property but more. Currently, it return in separate row one cell eg. rows[0].value will return Name, rows[1].value Value ... for me it is rubbish.</p>
  
  <p>I want to get all information in json array of object not all metadata or one property. There is a way to do this or there is a better connector for nodejs and sqlserver ?</p>