Execute 'SQL' Scripts in 'R' Containing Multiple Queries

The nature of working with structured query language ('SQL') scripts efficiently often requires the creation of temporary tables and there are few clean and simple 'R' 'SQL' execution approaches that allow you to complete this kind of work with the 'R' environment. This package seeks to give 'SQL' implementations in 'R' a little love by deploying functions that allow you to deploy complex 'SQL' scripts within a typical 'R' workflow.


SQLove

a lightweight R package for handling complex SQL scripts including temp tables, multiple queries, etc.

R-CMD-check

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.

install.packages("SQLove")

1.0.2 by Kerns Sam, 2 years ago


Browse source code at https://github.com/cran/SQLove


Authors: Kerns Sam [aut, cre]


Documentation:   PDF Manual  


MIT + file LICENSE license


Imports DBI, readr, RJDBC, odbc

Suggests knitr, rmarkdown


See at CRAN