node-mssql

What's Changed

• Fix README header for 8.x to 9.x upgrades by @jordanjennings in https://github.com/tediousjs/node-mssql/pull/1464
• Fix README to show node 12 no longer supported with 9.x by @jordanjennings in https://github.com/tediousjs/node-mssql/pull/1465
• Bump xml2js and @azure/keyvault-keys by @dependabot in https://github.com/tediousjs/node-mssql/pull/1485
• Add automated release workflows by @dhensby in https://github.com/tediousjs/node-mssql/pull/1502
• chore(ci): prevent dependabot pushes triggering appveyor events by @dhensby in https://github.com/tediousjs/node-mssql/pull/1508
• Bump @semantic-release/github from 9.0.3 to 9.0.4 by @dependabot in https://github.com/tediousjs/node-mssql/pull/1506
• Bump mocha from 10.0.0 to 10.2.0 by @dependabot in https://github.com/tediousjs/node-mssql/pull/1504
• Bump @tediousjs/connection-string from 0.4.1 to 0.4.2 by @dependabot in https://github.com/tediousjs/node-mssql/pull/1505
• Bump commander from 9.4.0 to 11.0.0 by @dependabot in https://github.com/tediousjs/node-mssql/pull/1507
• chore(ci): keep release jobs in a single concurrency group by @dhensby in https://github.com/tediousjs/node-mssql/pull/1509
• chore(deps-dev): bump word-wrap from 1.2.3 to 1.2.4 by @dependabot in https://github.com/tediousjs/node-mssql/pull/1510
• chore(ci): publish gh-pages with workflow by @dhensby in https://github.com/tediousjs/node-mssql/pull/1511
• chore(deps-dev): bump @commitlint/config-conventional from 17.6.6 to 17.6.7 by @dependabot in https://github.com/tediousjs/node-mssql/pull/1512
• chore(deps-dev): bump standard from 17.0.0 to 17.1.0 by @dependabot in https://github.com/tediousjs/node-mssql/pull/1513
• chore(deps-dev): bump @commitlint/cli from 17.6.6 to 17.6.7 by @dependabot in https://github.com/tediousjs/node-mssql/pull/1514
• chore(ci): fix page branch update by @dhensby in https://github.com/tediousjs/node-mssql/pull/1516
• Support named instances with ports by @dhensby in https://github.com/tediousjs/node-mssql/pull/1520

New Contributors

• @jordanjennings made their first contribution in https://github.com/tediousjs/node-mssql/pull/1464

Full Changelog: https://github.com/tediousjs/node-mssql/compare/v9.1.1...v9.1.2

What's Changed

• Revert support for AAD authentication via connection string by @Shin-Aska in https://github.com/tediousjs/node-mssql/pull/1436

Full Changelog: https://github.com/tediousjs/node-mssql/compare/v9.1.0...v9.1.1

What's Changed

• Fixing small typo in connecting with express documentation. by @MikeZ77 in https://github.com/tediousjs/node-mssql/pull/1433
• Added support for AAD authentication via connection string by @Shin-Aska in https://github.com/tediousjs/node-mssql/pull/1436
• Bump json5 from 1.0.1 to 1.0.2 by @dependabot in https://github.com/tediousjs/node-mssql/pull/1454
• Bump jsonwebtoken and @azure/msal-node by @dependabot in https://github.com/tediousjs/node-mssql/pull/1456

New Contributors

• @MikeZ77 made their first contribution in https://github.com/tediousjs/node-mssql/pull/1433
• @Shin-Aska made their first contribution in https://github.com/tediousjs/node-mssql/pull/1436

Full Changelog: https://github.com/tediousjs/node-mssql/compare/v9.0.1...v9.1.0

What's Changed

• Update tedious version support and lint fixes by @dhensby in https://github.com/tediousjs/node-mssql/pull/1417
• Dropped support for Node versions <= 12

Full Changelog: https://github.com/tediousjs/node-mssql/compare/v8.1.3...v9.0.0

What's Changed

• chore(msnodesqlv8/request): remove superfluous arg by @Fdawgs in https://github.com/tediousjs/node-mssql/pull/1408
• fix: requestTimeout option by @PopGoesTheWza in https://github.com/tediousjs/node-mssql/pull/1398
• Deny support for useColumnNames tedious option by @dhensby in https://github.com/tediousjs/node-mssql/pull/1416

New Contributors

• @Fdawgs made their first contribution in https://github.com/tediousjs/node-mssql/pull/1408
• @PopGoesTheWza made their first contribution in https://github.com/tediousjs/node-mssql/pull/1398

Full Changelog: https://github.com/tediousjs/node-mssql/compare/v8.1.2...v8.1.3

What's Changed

• Bump minimist from 1.2.5 to 1.2.6 by @dependabot in https://github.com/tediousjs/node-mssql/pull/1382
• Update README.md by @blitzmann in https://github.com/tediousjs/node-mssql/pull/1388
• Add square brackets to primary keys by @colgatto in https://github.com/tediousjs/node-mssql/pull/1394

New Contributors

• @blitzmann made their first contribution in https://github.com/tediousjs/node-mssql/pull/1388
• @colgatto made their first contribution in https://github.com/tediousjs/node-mssql/pull/1394

Full Changelog: https://github.com/tediousjs/node-mssql/compare/v8.1.0...v8.1.1

[fix] msnodesqlv8.js file was missing from previous release

What's Changed

• CI Support for msnodesqlv8 on node 10 (v7) by @dhensby in https://github.com/tediousjs/node-mssql/pull/1369
• Add square brackets to primary keys by @colgatto in https://github.com/tediousjs/node-mssql/pull/1394

New Contributors

• @colgatto made their first contribution in https://github.com/tediousjs/node-mssql/pull/1394

Full Changelog: https://github.com/tediousjs/node-mssql/compare/v7.3.1...v7.3.2

• Update CLI to accept options by @dhensby in https://github.com/tediousjs/node-mssql/pull/1381

What's Changed

• Add node 14 to test matrix by @dhensby in https://github.com/tediousjs/node-mssql/pull/1339
• Transaction/PreparedStatements expose the config from their parent connection (#1338)
• Inherited request configs from the pool. Specifically stream and arrayRowMode now inherit accurately from the connection config (#1338)

What's Changed

• Update mocha dependency by @dhensby in https://github.com/tediousjs/node-mssql/pull/1313
• chore: add devcontainer configuration by @arthurschreiber in https://github.com/tediousjs/node-mssql/pull/1315
• chore: fix the devcontainer configuration to work with local development containers and GitHub Codespaces by @arthurschreiber in https://github.com/tediousjs/node-mssql/pull/1316
• Update 7.x upgrade changes by @dhensby in https://github.com/tediousjs/node-mssql/pull/1327
• Bump dependencies by @dhensby in https://github.com/tediousjs/node-mssql/pull/1329
• Update tedious version by @dhensby in https://github.com/tediousjs/node-mssql/pull/1312
• fix typo connecton -> connection by @jlecordier in https://github.com/tediousjs/node-mssql/pull/1335
• Use a different driver in the msnodesqlv8 when on linux/mac by @0xA537FD in https://github.com/tediousjs/node-mssql/pull/1318
• Do not override explicitly provided driver options by @dhensby in https://github.com/tediousjs/node-mssql/pull/1340
• Allow rows that are null to be valid existing values by @dhensby in https://github.com/tediousjs/node-mssql/pull/1240
• Add table.rows.clear() method for chunking table row updates by @ttemple06 in https://github.com/tediousjs/node-mssql/pull/1094
• Remove connection string parser by @dhensby in https://github.com/tediousjs/node-mssql/pull/1342
• Update tarn & debug dependencies by @dhensby in https://github.com/tediousjs/node-mssql/pull/1344
• Remove duplicated info, improve clarity, add samples by @trevorbye in https://github.com/tediousjs/node-mssql/pull/1343
• Bump follow-redirects from 1.14.5 to 1.14.7 by @dependabot in https://github.com/tediousjs/node-mssql/pull/1353
• Allow processing of return column values by callback by @dhensby in https://github.com/tediousjs/node-mssql/pull/1356
• Update dependencies by @dhensby in https://github.com/tediousjs/node-mssql/pull/1357
• Remove deprecated pool properties by @dhensby in https://github.com/tediousjs/node-mssql/pull/1359
• Update readme changes for v7 - v8 upgrade by @dhensby in https://github.com/tediousjs/node-mssql/pull/1360

New Contributors

• @arthurschreiber made their first contribution in https://github.com/tediousjs/node-mssql/pull/1315
• @jlecordier made their first contribution in https://github.com/tediousjs/node-mssql/pull/1335
• @0xA537FD made their first contribution in https://github.com/tediousjs/node-mssql/pull/1318
• @ttemple06 made their first contribution in https://github.com/tediousjs/node-mssql/pull/1094
• @trevorbye made their first contribution in https://github.com/tediousjs/node-mssql/pull/1343

Full Changelog: https://github.com/tediousjs/node-mssql/compare/v7.2.1...v8.0.1

[new] Transaction/PreparedStatements expose the config from their parent connection (#1340)
[fix] Fix inherited request configs from the pool. Specifically stream and arrayRowMode now inherit accurately from the connection config (#1338)

[fix] Fix issue with bulk insert of dates (#1298)

[new] Update Geography field parsing to provide lat/lng props from Geography Point (#1282)
[fix] Handle errors when adding rows to bulk operations (#1264)
[fix] Input/Output parameter passing fix for msnodesqlv8 driver (#1275)

• [fix] Request timeout settings now respect value parsed from connection strings (#1257)

[fix] Errors from tedious connection creation now cause connection promise to reject #1254
[fix] Encrypt and transaction binding settings now respect value parsed from connection strings #1252

[new] Add parseJSON support to query strings (#1239)
[fix] Bump various dependencies for security fixes

[fix] Bump various dependencies for security fixes

[fix] Bump various dependencies for security fixes

[new] Result sets with duplicate keys can now be handled using request.arrayRowMode (#1130)
[new] Requests in stream mode now emit a rowsaffected event (#1213)
[new] msnodesqlv8 driver now has detailed error support (#1212)
[new] Connection validation checks before releasing connections from the pool. This can be turned of via validateConnection: false config option (#1192)
[new] UseUTC is now supported on msnodesqlv8 connections (#1222)
[change] Updated to latest Tedious 11
[change] Updated tarnjs to v3
[change] Updated to support latest msnodesqlv8 v2 (#1157)
[change] Piped streams no longer have errors forwarded on to them (#1028)
[change] tedious config option trustServerCertificate defaults to false if not supplied (#1030)
[change] Request.pipe now pipes a true node stream for better support of backpressure (#1078)
[change] drop support for NodeJS < 10 (#1070)
[fix] Ensure line endings are unix style (LF)
[fix] Avoid using deprecated .inspect on Objects (#1071)
[fix] Bump various dependencies for security fixes (#1102)
[fix] Trailing rows from request streams using msnodesqlv8 driver fail to be emitted (#1109)
[fix] Issue with geography v2 parsing resolve (#1138)
[fix] Connection config objects are now deep cloned when stored against a connection pool (#1217)