David Li

Would it be useful to implement this in a backend (e.g. DuckDB)? Effectively it would differ by not defining a view, instead inlining the table definition into the final query...

On Phillip's suggestion, now the ADBC package [implements](https://github.com/apache/arrow-adbc/pull/56) DBAPI, and this backend just defers to SQLAlchemy (except for fetching results, which gets overridden). I also added a bit of pytest...

What I ended up doing was futzing around so that the driver can also be distributed as a package: https://github.com/apache/arrow-adbc/pull/57 Once that gets updated, then instead of having to build...

I guess then we need to decide what specific backend(s) to target here? (Since this won't be as featureful as the existing SQLite driver, without being able to register UDFs.)...

In that case though, instead of trying to add all the pytest marks to get everything to pass, I'll focus on looking more into Substrait integration

@davisusanibar you already had a solution here I think, can you post it?

Or actually @Oooorchid see https://github.com/apache/arrow/pull/13788 FWIW, I believe the immediate problem in the code is the use of a string to transport the buffer over JNI. It should be byte[]....

https://github.com/apache/arrow/pull/13688 is a very similar PR for Parquet that takes a different implementation approach, I think it's worth coordinating.

We don't really assign reviewers, I bring it up because I noticed it and it is basically the same idea as this PR, from a quick glance - so I...

What's wrong with linking to the C++ docs? The format/ page for Flight RPC is meant more for things all implementations agree on, I don't think these tips really go...