Man pages for dbplyr
A 'dplyr' Back End for Databases
| arrange.tbl_lazy | Arrange rows by column values |
| backend-access | Backend: MS Access |
| backend-hana | Backend: SAP HANA |
| backend-hive | Backend: Hive |
| backend-impala | Backend: Impala |
| backend-mssql | Backend: SQL server |
| backend-mysql | Backend: MySQL/MariaDB |
| backend-odbc | Backend: ODBC |
| backend-oracle | Backend: Oracle |
| backend-postgres | Backend: PostgreSQL |
| backend-redshift | Backend: Redshift |
| backend-snowflake | Backend: Snowflake |
| backend-spark-sql | Backend: Databricks Spark SQL |
| backend-sqlite | Backend: SQLite |
| backend-teradata | Backend: Teradata |
| build_sql | Build a SQL string. |
| collapse.tbl_sql | Compute results of a query |
| complete.tbl_lazy | Complete a SQL table with missing combinations of data |
| 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 |
| db-io | Database I/O generics |
| db-misc | Miscellaneous database generics |
| dbplyr-package | dbplyr: A 'dplyr' Back End for Databases |
| dbplyr-slice | Subset rows using their positions |
| dbplyr_uncount | "Uncount" a database table |
| db-quote | SQL escaping/quoting generics |
| db-sql | SQL generation generics |
| distinct.tbl_lazy | Subset distinct/unique rows |
| do.tbl_sql | Perform arbitrary computation on remote backend |
| escape | Escape/quote a string. |
| expand.tbl_lazy | Expand SQL tables to include all possible combinations of... |
| fill.tbl_lazy | Fill in missing values with previous or next value |
| filter.tbl_lazy | Subset rows using column values |
| get_returned_rows | Extract and check the 'RETURNING' rows |
| 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 |
| ident_q | Declare a identifier as being pre-quoted. |
| in_schema | Refer to a table in another schema/catalog |
| intersect.tbl_lazy | SQL set operations |
| is_table_path | Table paths |
| join.tbl_sql | Join SQL tables |
| lahman | Cache and retrieve an 'src_sqlite' of the Lahman baseball... |
| lazy_ops | Lazy operations |
| memdb_frame | Create a database table in temporary in-memory database. |
| mutate.tbl_lazy | Create, modify, and delete columns |
| named_commas | Provides comma-separated string out of the parameters |
| nycflights13 | Database versions of the nycflights13 data |
| partial_eval | Partially evaluate an expression. |
| 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 |
| reexports | Objects exported from other packages |
| remote_name | Metadata about a remote table |
| replace_na.tbl_lazy | Replace NAs with specified values |
| rows-db | Edit individual rows in the underlying database table |
| select.tbl_lazy | Subset, rename, and reorder columns using their names |
| simulate_dbi | Simulate database connections |
| sql | SQL escaping. |
| sql_build | Build and render SQL from a sequence of lazy operations |
| sql_expr | Generate SQL from R expressions |
| sql_options | Options for generating SQL |
| sql_query_insert | Generate SQL for Insert, Update, Upsert, and Delete |
| sql_quote | Helper function for quoting sql elements. |
| sql_variant | Create an sql translator |
| src_dbi | Database src |
| src_sql | Create a "sql src" object |
| summarise.tbl_lazy | Summarise each group to one row |
| tbl_lazy | Create a local lazy tibble |
| tbl_sql | Create an SQL tbl (abstract) |
| tbl.src_dbi | Use dplyr verbs with a remote database table |
| testing | Infrastructure for testing dplyr |
| translate_sql | Translate an expression to SQL |
| window_order | Override window order and frame |
| win_over | Generate SQL expression for window functions |
