I understand that in flight sql driver the QUERY parameter is the one executed on the source db, and then the data is streamed back to DF.
What I don't understand it, why not send the unparsed sql directly, like in other DB providers? It would be way more efficient to push down any filters/projections (like it already works with SqlExec).
Clarifying edit: I obviously only mean the Flight SQL in particular, not Flight in general.
I understand that in flight sql driver the QUERY parameter is the one executed on the source db, and then the data is streamed back to DF.
What I don't understand it, why not send the unparsed sql directly, like in other DB providers? It would be way more efficient to push down any filters/projections (like it already works with SqlExec).
Clarifying edit: I obviously only mean the Flight SQL in particular, not Flight in general.