Learn R Programming
⚠️There's a newer version (2.5.2) of this package.Take me there.

dbplyr

dbplyr is the database backend for dbplyr.

If you find any bugs, please file in dplyr.

Copy Link

Version

Install

install.packages('dbplyr')

Monthly Downloads

593,873

Version

0.0.0.9000

License

MIT + file LICENSE

Issues

16

Pull Requests

4

Stars

504

Forks

187

Maintainer

Hadley Wickham

Last Published

February 13th, 2026

Functions in dbplyr (0.0.0.9000)

memdb_frame

Create a database table in temporary in-memory database.
lazy_ops

Lazy operations
build_sql

Build a SQL string.
join.tbl_sql

Join sql tbls.
do.tbl_sql

Perform arbitrary computation on remote backend
named_commas

Provides comma-separated string out ot the parameters
lahman

Cache and retrieve an
copy_to.src_sql

Copy a local data frame to a DBI backend.
testing

Infrastructure for testing dplyr
partial_eval

Partially evaluate an expression.
src_sql

Create a "sql src" object
sql_variant

Create an sql translator
reexports

Objects exported from other packages
sql_quote

Helper function for quoting sql elements.
tbl_sql

Create an SQL tbl (abstract)
sql

SQL escaping.
sql_build

Build and render SQL from a sequence of lazy operations
translate_sql

Translate an expression to sql.
src_dbi

dplyr backend for any DBI-compatible database
win_over

Generate SQL expression for window functions
nycflights13

Database versions of the nycflights13 data
db_copy_to

More db generics