[Python] Add FlightSql client bindings

[danepitkin]

Describe the enhancement requested

PyArrow currently only implements bindings to Arrow Flight RPC (not Arrow Flight SQL). There already exists a python Flight SQL driver in the ADBC repo[1]. We can implement a python Flight SQL client in PyArrow by wrapping the Arrow C++ Flight SQL client. The PyArrow Flight RPC implementation is here[2] for reference.

[1]https://github.com/apache/arrow-adbc/tree/main/python/adbc_driver_flightsql
[2]https://github.com/apache/arrow/blob/main/python/pyarrow/flight.py

Component(s)

Python

[jorisvandenbossche]

For reference, the C++ Client is defined here:

arrow/cpp/src/arrow/flight/sql/client.h

Lines 44 to 51 in 40a8a68

	/// \brief Flight client with Flight SQL semantics.
	///
	/// Wraps a Flight client to provide the Flight SQL RPC calls.
	class ARROW_FLIGHT_SQL_EXPORT FlightSqlClient {
	friend class PreparedStatement;
	private:
	std::shared_ptr<FlightClient> impl_;

(added in the original Flight SQL PR #12013)

[github-actions]

This issue has been marked as stale because it has had no activity in the past 365 days. Please remove the stale label or comment below, or this issue will be closed in 14 days. If this improvement is still desired but has no current owner, please add the 'Status: needs champion' label.