Re: [I] Placeholder syntax in parametrized queries [arrow-adbc]

["paleolimbot (via GitHub)" <gi...@apache.org>]

paleolimbot commented on issue #1397:
URL: https://github.com/apache/arrow-adbc/issues/1397#issuecomment-1867719840

   Rather than try to specify some regex or "bind pattern", I wonder if we just want to push the "bind by name" operation into the driver. For example:
   
   ```r
   adbc_statement_bind_by_name <- function(statement, stream) {
     UseMethod("adbc_statement_bind_by_name")
   }
   
   adbc_statement_bind_by_name.default <- function(statement, stream) {
     stop("bind by name not supported by this driver")  # maybe throw a classed error that you can catch
   }
   ```
   
   The implementation for SQLite, for example, could use the parameter schema method (probably stealing the implementation from RSQLite).


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org