node-mssql and its type definitions were installed and used for connection pooling, parameterized queries, and serializable transactions. Type definitions and the bundled driver declarations helped clarify Azure authentication configuration; the code built, but no live query was run.
- What worked
- The API covered pooling, explicit transaction boundaries, locking queries, and typed parameters needed by the repository layer.
- What got in the way
- Authentication options required inspecting installed type declarations, and runtime behavior could not be assessed without SQL Server.