[ARROW-9825] [FlightRPC] Add a "Flight SQL" extension on top of FlightRPC

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: FlightRPC, Format
• External issue URL: https://github.com/apache/arrow/issues/25865
• Assignee: Unassigned
• Reporter: Ryan Nicholson
• Created: 22/Aug/20 00:44
• Updated: 11/Jan/23 08:09
• Resolved: 22/Apr/22 15:53

Description

As a developer of database clients and backends, I would like to have a standard in place to communicate between the two while being able to leverage the data transfer features of Arrow Flight.

The Arrow Flight RPC specification allows for extensibility by using opaque payloads to perform “Actions”, specify “Commands” and so on.

I propose the addition of a Flight SQL extension consisting of predefined protobuf messages and workflows to enable features such as:

• Discovering specific database capabilities from generic clients
• Browsing catalogs.
• Execution of different types of SQL commands.

Supporting documentation and a POC changelist will be sent to the mailing list in the coming days which describes protobuf messages and workflows enabling these features.

Issue Links

• is related to: ARROW-7744 [FlightRPC][Java] Implement Flight SQL JDBC Driver