Investigate supporting FlightSQL

[matthewmturner]

No description provided.

[backkem]

Note that there are FlightSQL table provider implementations:

• datafusion-contrib/datafusion-table-provider-flight: pure table provider.
• datafusion-contrib/datafusion-federation flight-sql example: FlightSQL federation. Allowing whole parts of the logical plan to be sent to the remote as SQL or Substrait.

(Note: the above may be merged and moved to datafusion-contrib/datafusion-table-providers, see this comment.

[matthewmturner]

@backkem Noted, thanks for pointing that out.

My original goal with FlightSQL was to embed a client and have displays for metadata / catalog information. I don't think that and what you mention are mutually exclusive though.

[backkem]

Indeed, these TableProvider implementations allow you to query via FlightSQL. I'm not sure if catalog inspection is implemented yet but that would also make sense.

[matthewmturner]

@backkem FYI there is a FlightSQL client now. Next week I should be able to look into the flightsql TableProviderFactory in datafusion-table-providers