# A 'dplyr' Back End for Databases

## Documentation for package ‘dbplyr’ version 2.1.1

- DESCRIPTION file.
- User guides, package vignettes and other documentation.

## Help Pages

anti_join.tbl_lazy | Join SQL tables
arrange.tbl_lazy | Arrange rows by column values
as.sql | SQL escaping.
collapse.tbl_sql | Compute results of a query
collect.tbl_sql | Compute results of a query
complete.tbl_lazy | Complete a SQL table with missing combinations of data
compute.tbl_sql | Compute results of a query
copy_to.src_sql | Copy a local data frame to a remote database
count.tbl_lazy | Count observations by group
dbplyr_uncount | "Uncount" a database table
distinct.tbl_lazy | Subset distinct/unique rows
do.tbl_sql | Perform arbitrary computation on remote backend
escape | Escape/quote a string.
escape_ansi | Escape/quote a string.
expand.tbl_lazy | Expand SQL tables to include all possible combinations of values
fill.tbl_lazy | Fill in missing values with previous or next value
filter.tbl_lazy | Subset rows using column values
full_join.tbl_lazy | Join SQL tables
group_by.tbl_lazy | Group by one or more variables
head.tbl_lazy | Subset the first rows
ident | Flag a character vector as SQL identifiers
inner_join.tbl_lazy | Join SQL tables
intersect.tbl_lazy | SQL set operations
in_schema | Refer to a table in a schema
is.ident | Flag a character vector as SQL identifiers
is.sql | SQL escaping.
join.tbl_sql | Join SQL tables
left_join.tbl_lazy | Join SQL tables
memdb_frame | Create a database table in temporary in-memory database.
mutate.tbl_lazy | Create, modify, and delete columns
pivot_longer.tbl_lazy | Pivot data from wide to long
pivot_wider.tbl_lazy | Pivot data from long to wide
pull.tbl_sql | Extract a single column
relocate.tbl_lazy | Subset, rename, and reorder columns using their names
remote_con | Metadata about a remote table
remote_name | Metadata about a remote table
remote_query | Metadata about a remote table
remote_query_plan | Metadata about a remote table
remote_src | Metadata about a remote table
rename.tbl_lazy | Subset, rename, and reorder columns using their names
rename_with.tbl_lazy | Subset, rename, and reorder columns using their names
replace_na.tbl_lazy | Replace NAs with specified values
right_join.tbl_lazy | Join SQL tables
select.tbl_lazy | Subset, rename, and reorder columns using their names
semi_join.tbl_lazy | Join SQL tables
setdiff.tbl_lazy | SQL set operations
simulate_access | Backend: MS Access
simulate_hana | Backend: SAP HANA
simulate_mysql | Backend: MySQL/MariaDB
simulate_odbc | Backend: ODBC
simulate_oracle | Backend: Oracle
simulate_postgres | Backend: PostgreSQL
simulate_redshift | Backend: Redshift
simulate_snowflake | Backend: Snowflake
simulate_sqlite | Backend: SQLite
simulate_teradata | Backend: Teradata
slice_max.tbl_lazy | Subset rows using their positions
slice_min.tbl_lazy | Subset rows using their positions
slice_sample.tbl_lazy | Subset rows using their positions
sql | SQL escaping.
sql_vector | Escape/quote a string.
src_memdb | Create a database table in temporary in-memory database.
summarise.tbl_lazy | Summarise each group to one row
tally.tbl_lazy | Count observations by group
tbl.src_dbi | Use dplyr verbs with a remote database table
tbl_dbi | Use dplyr verbs with a remote database table
tbl_memdb | Create a database table in temporary in-memory database.
translate_sql | Translate an expression to sql
translate_sql_ | Translate an expression to sql
union.tbl_lazy | SQL set operations
union_all.tbl_lazy | SQL set operations
window_frame | Override window order and frame
window_order | Override window order and frame