Bind values to a parameterized/prepared statement — dbBind

For parametrized or prepared statements, the dbSendQuery(), dbSendQueryArrow(), and dbSendStatement() functions can be called with statements that contain placeholders for values. The dbBind() and dbBindArrow() functions bind these placeholders to actual values, and are intended to be called on the result set before calling dbFetch() or dbFetchArrow(). The values are passed to dbBind() as lists or data frames, and to dbBindArrow() as a stream created by nanoarrow::as_nanoarrow_array_stream(). dbBindArrow() is experimental, as are the other *Arrow functions. dbSendQuery() is compatible with dbBindArrow(), and dbSendQueryArrow() is compatible with dbBind(). Methods in other packagesThis documentation page describes the generics. Refer to the documentation pages linked below for the documentation for the methods that are implemented in various backend packages. adbi::dbBind("AdbiResult") adbi::dbBind("AdbiResultArrow") bigrquery::dbBind("BigQueryResult") duckdb::dbBind("duckdb_result") odbc::dbBind("OdbcResult") RMariaDB::dbBind("MariaDBResult") RPostgres::dbBind("PqResult") RSQLite::dbBind("SQLiteResult") sparklyr::dbBind("DBISparkResult")