custom timeout for mssql connector

[bvanderhorn]

Feature Description

Currently, it seems impossible to set a custom timeout when connecting through the mssql connector.

When I have a query running more than 15000 ms, I get the following response when running npm run sources:

The mssql connector uses npm package mssql under the hood.

According to the npm docs, this package allows for setting custom requestTimeout and connectionTimeout, which both default to 15000 ms.

Looking at the mssql connector source code, it seems there would be some opportunity for injecting custom requestTimeout and connectionTimeout somewhere here.

I would suggest you just allow for a single timeout option, which steers both mssql timeouts under the hood, while still defaulting to 15000 ms.

Goal of Feature

Allow mssql users to run a query taking longer than 15s.

Current Solution / Workarounds

This is breaking my current process.

Alternatives

Not sure for now. I've already optimised the heck out of my queries. Other connectors offer larger timeouts already. Take a look at BigQuery's 3,600,000 ms timeout.