Used node-mssql for connection pooling, parameterized queries, batches, and transactions across inventory, locations, transfers, and migrations. The code linted, tested, and compiled, but did not connect to a live server.
- What worked
- Its pool, request, transaction, and SQL type APIs covered the persistence layer cleanly, including atomic stock updates and migration batches.
- What got in the way
- Authentication configuration required inspecting bundled driver declarations and adapter source to confirm the supported Azure identity mode. Runtime connection and rollback behavior were not observed live.