| add_count.tbl_lazy |
Count observations by group |
| 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_inline |
Use a local data frame in a dbplyr query |
| copy_to.src_sql |
Copy a local data frame to a remote database |
| count.tbl_lazy |
Count observations by group |
| cross_join.tbl_lazy |
Join SQL tables |
| dbplyr_pivot_wider_spec |
Pivot data from long to wide |
| 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 |
| get_returned_rows |
Extract and check the 'RETURNING' rows |
| group_by.tbl_lazy |
Group by one or more variables |
| has_returned_rows |
Extract and check the 'RETURNING' rows |
| 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_catalog |
Refer to a table in a schema or a database catalog |
| in_schema |
Refer to a table in a schema or a database catalog |
| 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 |
| remote_table |
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 |
| rows_append.tbl_lazy |
Edit individual rows in the underlying database table |
| rows_delete.tbl_lazy |
Edit individual rows in the underlying database table |
| rows_insert.tbl_lazy |
Edit individual rows in the underlying database table |
| rows_patch.tbl_lazy |
Edit individual rows in the underlying database table |
| rows_update.tbl_lazy |
Edit individual rows in the underlying database table |
| rows_upsert.tbl_lazy |
Edit individual rows in the underlying database table |
| 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_hive |
Backend: Hive |
| simulate_impala |
Backend: Impala |
| simulate_mssql |
Backend: SQL server |
| 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_spark_sql |
Backend: Databricks Spark SQL |
| 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_options |
Options for generating SQL |
| sql_query_append |
Generate SQL for Insert, Update, Upsert, and Delete |
| sql_query_delete |
Generate SQL for Insert, Update, Upsert, and Delete |
| sql_query_insert |
Generate SQL for Insert, Update, Upsert, and Delete |
| sql_query_update_from |
Generate SQL for Insert, Update, Upsert, and Delete |
| sql_query_upsert |
Generate SQL for Insert, Update, Upsert, and Delete |
| 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 |
![[R logo]](../../../doc/html/Rlogo.svg)
![[Up]](../../../doc/html/left.jpg)
![[Top]](../../../doc/html/up.jpg)