Skip to content

Instantly share code, notes, and snippets.

@jimhester
Last active November 28, 2017 19:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jimhester/350e770b8e31aa1fb6cff076a8c2f169 to your computer and use it in GitHub Desktop.
Save jimhester/350e770b8e31aa1fb6cff076a8c2f169 to your computer and use it in GitHub Desktop.
```{r setup}
library(DBI)
con <- dbConnect(RSQLite::SQLite(), ":memory:")
dbWriteTable(con, "mtcars", mtcars)
library(glue)
```
```{r}
tbl <- "mtcars"
```
```{r engine = "glue_sql", connection = "con"}
SELECT * FROM {`tbl`} where gear IN ({3:4*})
```
```{gluesql connection = "con"}
SELECT * FROM {`tbl`} where gear IN ({3:4*})
```
```{r engine = "glue"}
First three letters are {letters[1:3]}
```
```{r engine = "glue"}
NA = {NA}
```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment