A 'dplyr' Back End for Databases
Arrange rows by column values
Backend: MS Access
Backend: SAP HANA
Backend: Hive
Backend: Impala
Backend: SQL server
Backend: MySQL/MariaDB
Backend: ODBC
Backend: Oracle
Backend: PostgreSQL
Backend: Redshift
Backend: Snowflake
Backend: Databricks Spark SQL
Backend: SQLite
Backend: Teradata
Build a SQL string.
Compute results of a query
Complete a SQL table with missing combinations of data
Use a local data frame in a dbplyr query
Copy a local data frame to a remote database
Count observations by group
Database I/O generics
Miscellaneous database generics
SQL escaping/quoting generics
SQL generation generics
dbplyr: A 'dplyr' Back End for Databases
Subset rows using their positions
"Uncount" a database table
Subset distinct/unique rows
Perform arbitrary computation on remote backend
Escape/quote a string.
Expand SQL tables to include all possible combinations of values
Fill in missing values with previous or next value
Subset rows using column values
Extract and check the RETURNING rows
Group by one or more variables
Subset the first rows
Flag a character vector as SQL identifiers
Declare a identifier as being pre-quoted.
Refer to a table in another schema/catalog
SQL set operations
Table paths
Join SQL tables
Cache and retrieve an src_sqlite of the Lahman baseball database.
Lazy operations
Create a database table in temporary in-memory database.
Create, modify, and delete columns
Provides comma-separated string out of the parameters
Database versions of the nycflights13 data
Partially evaluate an expression.
Pivot data from wide to long
Pivot data from long to wide
Extract a single column
Objects exported from other packages
Metadata about a remote table
Replace NAs with specified values
Edit individual rows in the underlying database table
Subset, rename, and reorder columns using their names
Simulate database connections
SQL escaping.
Build and render SQL from a sequence of lazy operations
Generate SQL from R expressions
Options for generating SQL
Generate SQL for Insert, Update, Upsert, and Delete
Helper function for quoting sql elements.
Create an sql translator
Database src
Create a "sql src" object
Summarise each group to one row
Use dplyr verbs with a remote database table
Create a local lazy tibble
Create an SQL tbl (abstract)
Infrastructure for testing dplyr
Translate an expression to SQL
Generate SQL expression for window functions
Override window order and frame
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.
Useful links