[C++] Native Arrow interface to sqlite3

[asfimport]

It would be valuable to be able to query a SQLite3 database file and return an Arrow record batch natively

Reporter: Wes McKinney / @wesm

Related issues:

• [C++] SQLite record batch reader (is duplicated by)

_{Note: This issue was originally created as ARROW-3102. Please see the migration documentation for further details.}

[asfimport]

Antoine Pitrou / @pitrou:
Is this something we would still like to do inside Arrow, or do we want to promote the use of the C data interface by third-party client libraries instead?

[asfimport]

Wes McKinney / @wesm:
Multiple questions here:

• Where to develop and maintain code?

• How to build this particular component?

  When it comes to middlewares like this that are interacting with a C-library, it might be nice for them to be unburdened by the C++ build toolchain, but to do that you need to build the Arrow data structures in C. I'd be interested in having a small portable C Arrow implementation that provides some builders and exports the C data interface that projects like this could develop against. See also ARROW-1851

  An alternative of course would be to just build this as an add-on/contrib component for the C++ project.

[asfimport]

Wes McKinney / @wesm:
On the first question, if there is community interest in building and maintaining such a component in Apache Arrow, I see no reason why not.