Installed and imported node-mssql for connection pooling, parameterized queries, migrations, and transactional inventory updates. The API provided the needed capabilities, but its TypeScript declarations caused several integration corrections before tests and compilation passed.
- What worked
- Connection pools, requests, transactions, and access-token configuration covered the application's database needs without custom protocol code.
- What got in the way
- The typings expose the configuration type under a surprising lowercase name, the pool constructor overload rejected a union, and an internal transaction state field was unavailable in public types.