fix: extend sql middleware for mssql, azure_synapse and clickhouse

[achettyiitr]

Description

• Extend SQL middleware to MSSQL, AZURE SYNAPSE, CLICKHOUSE

Linear Ticket

• https://linear.app/rudderstack/issue/PIPE-174/extend-sql-middleware-to-remaining-destinations

Security

• The code changed/added as part of this pull request won't create any security issues with how the software is being used.

[codecov]

Codecov Report

Patch coverage: 77.15% and project coverage change: -0.49% ⚠️

Comparison is base (e6892a2) 68.64% compared to head (3d286f3) 68.15%.
Report is 1 commits behind head on release/1.12.x.

Additional details and impacted files

@@                Coverage Diff                 @@
##           release/1.12.x    #3771      +/-   ##
==================================================
- Coverage           68.64%   68.15%   -0.49%     
==================================================
  Files                 337      334       -3     
  Lines               52467    51557     -910     
==================================================
- Hits                36014    35138     -876     
+ Misses              14146    14134      -12     
+ Partials             2307     2285      -22     

Files Changed	Coverage Δ
...ehouse/integrations/azure-synapse/azure-synapse.go	62.95% <72.72%> (+0.37%)	⬆️
warehouse/integrations/mssql/mssql.go	64.03% <72.72%> (+0.04%)	⬆️
warehouse/integrations/clickhouse/clickhouse.go	77.25% <80.00%> (-0.58%)	⬇️
warehouse/integrations/manager/manager.go	92.85% <100.00%> (ø)

... and 17 files with indirect coverage changes

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

[fracasula]

PR looks good, although I don't understand how this would solve the code from getting stuck. Perhaps I'm missing some context so I'll have a look at the goroutine dumps you posted as well. I don't see a reason why this shouldn't be merged though so I'm approving 👍

[achettyiitr]

PR looks good, although I don't understand how this would solve the code from getting stuck. Perhaps I'm missing some context so I'll have a look at the goroutine dumps you posted as well. I don't see a reason why this shouldn't be merged though so I'm approving 👍

Queries got stuck during fetch schema and delete for more than 5 hours. With timeouts, we will fail fast and retry.