Package: dbplyr 2.5.2.9000
Hadley Wickham
dbplyr: A 'dplyr' Back End for Databases
A 'dplyr' back end for databases that allows you to work with remote database tables as if they are in-memory data frames. Basic features works with any database that has a 'DBI' back end; more advanced features require 'SQL' translation to be provided by the package author.
Authors:
dbplyr_2.5.2.9000.tar.gz
dbplyr_2.5.2.9000.zip(r-4.6)dbplyr_2.5.2.9000.zip(r-4.5)dbplyr_2.5.2.9000.zip(r-4.4)
dbplyr_2.5.2.9000.tgz(r-4.6-any)dbplyr_2.5.2.9000.tgz(r-4.5-any)
dbplyr_2.5.2.9000.tar.gz(r-4.6-any)dbplyr_2.5.2.9000.tar.gz(r-4.5-any)
dbplyr_2.5.2.9000.tgz(r-4.5-emscripten)
dbplyr.pdf |dbplyr.html✨
dbplyr/json (API)
NEWS
| # Install 'dbplyr' in R: |
| install.packages('dbplyr', repos = c('https://tidyverse.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/tidyverse/dbplyr/issues
Pkgdown/docs site:https://dbplyr.tidyverse.org
Last updated from:d5184b3e2d. Checks:9 OK. Indexed: yes.
| Target | Result | Total time | Artifact |
|---|---|---|---|
| linux-devel-x86_64 | OK | 194 | |
| source / vignettes | OK | 244 | |
| linux-release-x86_64 | OK | 193 | |
| macos-devel-arm64 | OK | 232 | |
| macos-release-arm64 | OK | 167 | |
| windows-devel | OK | 269 | |
| windows-release | OK | 186 | |
| windows-oldrel | OK | 198 | |
| wasm-release | OK | 112 |
Exports:.sqlas_table_pathas.sqlbase_aggbase_no_winbase_odbc_aggbase_odbc_scalarbase_odbc_winbase_scalarbase_winbind_queriesbuild_sqlcheck_table_pathcopy_inlinecopy_lahmancopy_nycflights13db_col_typesdb_collectdb_computedb_connection_describedb_copy_todb_sql_renderdb_table_drop_if_existsdbplyr_editiondbplyr_pivot_wider_specdbplyr_uncountdialect_accessdialect_ansidialect_hanadialect_hivedialect_impaladialect_mariadbdialect_mssqldialect_mysqldialect_odbcdialect_oracledialect_postgresdialect_redshiftdialect_snowflakedialect_spark_sqldialect_sqlitedialect_teradataescapeescape_ansiget_returned_rowshas_lahmanhas_nycflights13has_returned_rowsidentident_qin_catalogin_schemais_table_pathis.identis.sqllahman_mysqllahman_postgreslahman_sqlitelahman_srcslast_sqllazy_base_querylazy_framelazy_multi_join_querylazy_querylazy_rf_join_querylazy_select_querylazy_semi_join_querylazy_set_op_querylazy_union_querylocal_memdb_framememdbmemdb_framenamed_commasnew_sql_dialectnycflights13_postgresnycflights13_sqliteop_frameop_grpsop_sortop_varspartial_evalremote_conremote_nameremote_queryremote_query_planremote_srcremote_tablerf_join_queryselect_querysemi_join_queryset_op_querysimulate_accesssimulate_dbisimulate_hanasimulate_hivesimulate_impalasimulate_mariadbsimulate_mssqlsimulate_mysqlsimulate_odbcsimulate_oraclesimulate_postgressimulate_redshiftsimulate_snowflakesimulate_spark_sqlsimulate_sqlitesimulate_teradatasqlsql_aggregatesql_aggregate_2sql_aggregate_nsql_buildsql_call2sql_castsql_check_na_rmsql_cotsql_dialectsql_escape_datesql_escape_datetimesql_escape_identsql_escape_logicalsql_escape_rawsql_escape_stringsql_exprsql_expr_matchessql_gluesql_glue2sql_indent_subquerysql_infixsql_join_suffixsql_logsql_not_supportedsql_optimisesql_optionssql_pastesql_paste_infixsql_prefixsql_query_appendsql_query_deletesql_query_explainsql_query_fieldssql_query_insertsql_query_joinsql_query_multi_joinsql_query_rowssql_query_savesql_query_selectsql_query_semi_joinsql_query_set_opsql_query_unionsql_query_update_fromsql_query_upsertsql_query_wrapsql_quotesql_randomsql_rendersql_returning_colssql_runifsql_set_op_methodsql_str_subsql_substrsql_table_analyzesql_table_indexsql_table_temporarysql_translationsql_translatorsql_try_castsql_variantsql_vectorsrc_dbisrc_memdbsrc_sqltable_path_componentstable_path_nametbl_lazytbl_memdbtbl_sqltranslate_sqltranslate_sql_union_querywin_absentwin_aggregatewin_aggregate_2win_cumulativewin_current_framewin_current_groupwin_current_orderwin_overwin_rankwin_recycledwindow_framewindow_orderwith_dialect
Dependencies:blobclicpp11DBIdplyrgenericsgluelifecyclemagrittrpillarpkgconfigpurrrR6rlangstringistringrtibbletidyrtidyselectutf8vctrswithr
Developing a dbplyr backend
Rendered fromnew-backend.Rmdusingknitr::rmarkdownon Feb 13 2026.Last update: 2026-01-14
Started: 2017-04-02
Function translation
Rendered fromtranslation-function.Rmdusingknitr::rmarkdownon Feb 13 2026.Last update: 2026-01-05
Started: 2019-01-10
Introduction to dbplyr
Rendered fromdbplyr.Rmdusingknitr::rmarkdownon Feb 13 2026.Last update: 2025-12-15
Started: 2017-04-02
Reprexes for dbplyr
Rendered fromreprex.Rmdusingknitr::rmarkdownon Feb 13 2026.Last update: 2025-12-18
Started: 2019-02-05
Verb translation
Rendered fromtranslation-verb.Rmdusingknitr::rmarkdownon Feb 13 2026.Last update: 2025-12-22
Started: 2019-01-10
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Flag SQL function usage | .sql |
| Arrange rows by column values | arrange.tbl_lazy |
| MS Access backend | dialect_access simulate_access |
| ANSI SQL backend | dialect_ansi simulate_dbi |
| SAP HANA backend | dialect_hana simulate_hana |
| Hive backend | dialect_hive simulate_hive |
| Impala backend | dialect_impala simulate_impala |
| JDBC backend | backend-jdbc |
| SQL Server backend | dialect_mssql simulate_mssql |
| MySQL/MariaDB backend | dialect_mariadb dialect_mysql simulate_mariadb simulate_mysql |
| ODBC backend | dialect_odbc simulate_odbc |
| Oracle backend | dialect_oracle simulate_oracle |
| PostgreSQL backend | dialect_postgres simulate_postgres |
| Redshift backend | dialect_redshift simulate_redshift |
| Snowflake backend | dialect_snowflake simulate_snowflake |
| Databricks Spark SQL backend | dialect_spark_sql simulate_spark_sql |
| SQLite backend | dialect_sqlite simulate_sqlite |
| Teradata backend | dialect_teradata simulate_teradata |
| Combine multiple lazy queries | bind_queries |
| Collapse a query into a subquery | collapse.tbl_sql |
| Collect results into a local data frame | collect.tbl_sql |
| Complete a SQL table with missing combinations of data | complete.tbl_lazy |
| Save results into a new remote table | compute.tbl_sql |
| Use a local data frame in a dbplyr query | copy_inline |
| Copy a local data frame to a remote database | copy_to.src_sql |
| Count observations by group | add_count.tbl_lazy count.tbl_lazy tally.tbl_lazy |
| "Uncount" a database table | dbplyr_uncount |
| Subset rows using their positions | slice_max.tbl_lazy slice_min.tbl_lazy slice_sample.tbl_lazy |
| Subset distinct/unique rows | distinct.tbl_lazy |
| Perform arbitrary computation on remote backend | do.tbl_sql |
| Escape/quote a value | db-quote escape sql_escape_date sql_escape_datetime sql_escape_ident sql_escape_logical sql_escape_raw sql_escape_string sql_vector |
| Expand SQL tables to include all possible combinations of values | expand.tbl_lazy |
| Fill in missing values with previous or next value | fill.tbl_lazy |
| Subset rows using column values | filter.tbl_lazy |
| Extract and check the 'RETURNING' rows | get_returned_rows has_returned_rows |
| Group by one or more variables | group_by.tbl_lazy |
| Subset the first rows | head.tbl_lazy |
| SQL set operations | intersect.tbl_lazy setdiff.tbl_lazy union.tbl_lazy union_all.tbl_lazy |
| Join SQL tables | anti_join.tbl_lazy cross_join.tbl_lazy full_join.tbl_lazy inner_join.tbl_lazy join.tbl_sql left_join.tbl_lazy right_join.tbl_lazy semi_join.tbl_lazy |
| Retrieve the last SQL query generated | last_sql |
| A temporary in-memory database | local_memdb_frame memdb memdb_frame |
| Create, modify, and delete columns | mutate.tbl_lazy |
| Pivot data from wide to long | pivot_longer.tbl_lazy |
| Pivot data from long to wide | dbplyr_pivot_wider_spec pivot_wider.tbl_lazy |
| Extract a single column | pull.tbl_sql |
| Metadata about a remote table | remote_con remote_name remote_query remote_query_plan remote_src remote_table |
| Replace NAs with specified values | replace_na.tbl_lazy |
| Edit individual rows in the underlying database table | rows_append.tbl_lazy rows_delete.tbl_lazy rows_insert.tbl_lazy rows_patch.tbl_lazy rows_update.tbl_lazy rows_upsert.tbl_lazy |
| Subset, rename, and reorder columns using their names | relocate.tbl_lazy rename.tbl_lazy rename_with.tbl_lazy select.tbl_lazy |
| Show generated SQL and query plan | explain.tbl_sql show_query show_query.tbl_lazy |
| Literal SQL escaping | is.sql sql |
| SQL dialects | new_sql_dialect sql_dialect |
| Build SQL strings with glue syntax | sql_glue sql_glue2 |
| Options for generating SQL | sql_options |
| Generate SQL for Insert, Update, Upsert, and Delete | sql_query_append sql_query_delete sql_query_insert sql_query_update_from sql_query_upsert |
| SQL helpers for aggregate functions | sql_aggregate sql_aggregate_2 sql_aggregate_n sql_check_na_rm sql_not_supported sql_translation_agg |
| SQL helpers for scalar functions | sql_cast sql_cot sql_infix sql_log sql_prefix sql_runif sql_translation_scalar sql_try_cast |
| SQL helpers for string functions | sql_paste sql_paste_infix sql_str_sub sql_substr sql_translation_string |
| SQL helpers for window functions | sql_translation_window win_absent win_aggregate win_aggregate_2 win_cumulative win_current_frame win_current_group win_current_order win_over win_rank win_recycled |
| Create an SQL translator | base_agg base_no_win base_odbc_agg base_odbc_scalar base_odbc_win base_scalar base_win sql_translator sql_variant |
| Summarise each group to one row | summarise.tbl_lazy |
| Create a lazy query backed by a database | tbl.src_dbi tbl_dbi |
| Translate an expression to SQL | translate_sql translate_sql_ |
| Override window order and frame | window_frame window_order |
| Override the SQL dialect for a connection | with_dialect |
