SamArch27 commented on issue #13: URL: https://github.com/apache/arrow-adbc/issues/13#issuecomment-4665928186
I have some suggestions for a generic table `SELECT` API. ### Generic table and schema names Users should be able to set an option (similar to `ADBC_INGEST_OPTION_TARGET_TABLE`) to specify a target table and schema to read from. This would make it easy to perform `SELECT * FROM "schema"."table"` queries which work across multiple systems (even if those systems use different delimiters). ### Projection, Filter, and Limit Pushdown Users should be able to provide a simplified query plan (possibly Substrait) instead of a SQL query string for execution. A plan-based API would enable pushdown of projections (dropping unused columns), filters (pruning of irrelevant rows), and limits (early termination of entire queries) leading to better performance. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
