In paulhendricks/queryr: Tools for Querying SQL Databases from R

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>",
  fig.path = "README-"
)

queryr

queryr provides tools to aid in querying SQL databases through R.

Installation

You can install:

• the latest released version from CRAN with

  ```R install.packages("queryr") ````

• the latest development version from github with

  R if (packageVersion("devtools") < 1.6) { install.packages("devtools") } devtools::install_github("paulhendricks/queryr")

If you encounter a clear bug, please file a minimal reproducible example on github.

API

library(dplyr, warn.conflicts = FALSE)
library(queryr)
raw_qry <- 
"
SELECT * 

FROM SOME_TABLE

WHERE CONDITION 

GROUP BY VARIABLES;
"

raw_qry %>% remove_whitespace
raw_qry %>% remove_whitespace %>% remove_semicolon

paulhendricks/queryr documentation built on May 24, 2019, 8:43 p.m.