DBIsqldf

Provides an easy way to perform SQL selects on R data frames.

The package contains a single function sqldf() whose help file contains more information and examples.

This package is a fork from the original sqldf-package.

The primary differences are:

• DBI interface only. This increases compatibility with database drivers, but at the expense of database-specific convenience features.
• DBI native parameterized query support.
• More conservative defaults for writing tables - data frames are imported as temporary tables and should be committed explicitly is they need to be persisted.
• No legacy (transitive) dependencies.

Installation

remotes::install_github("nfultz/DBIsqldf")