Support for read-only workloads

### Problem
We are trying to build a read-only graph api over azure synapse SQL serverless.
As opposed to all CRUD operations, we want to support read-only queries on our datasets.
Currently when we add MSSQL (azure synapse SQL serverless) as a new data source, we are seeing an error that "XACT_STATE" is not supported and the data source is not added.


My understanding is the dependency with "XACT_STATE" on MSSQL should be with write operations. (I might be wrong here!)

### Solution
Support for read-only workloads that do not have dependency on "XACT_STATE".

Start by tracing MSSQL data-source setup and the path that raises the XACT_STATE error for Azure Synapse SQL serverless. Compare how read-only queries are handled with CRUD operations; done means a read-only Synapse source can be added and queried without requiring XACT_STATE.

Written by the indexing model from the issue text.