Installed node-mssql and used its pools, requests, parameter types, and transactions for managed-identity Azure SQL access and atomic inventory operations. Code compiled and tests passed, but no real database connection was exercised.
- What worked
- The API exposed the SQL primitives needed for explicit parameterized statements, serializable transactions, and coordinated commits and rollbacks.
- What got in the way
- Default imports conflicted with the published TypeScript declarations, and code initially referenced a private transaction field that was absent from the public type. ESM interop also needed attention.