Common Data Service Legacy Connector and Native Query

Hello

Does Common Data Service Connector supports native queries.

If yes, can You post some working example?

I need to get more than an 80Mo from a TDS endpoint via a native query and trying to find an easy alternative (wrt recommended Azure Synapse Link)

Thank You