between operator in sqlite

[rpremraj]

Hi,

Can dplyr support the between operator when working with sqlite?

Sadly the following fails:

data <- lahman_sqlite()
tbl(data, "AllstarFull") %>% filter(between(yearID, 1933, 1947))
Source: sqlite 3.7.17 [C:\Users\.../lahman.sqlite]
Error in sqliteExecStatement(conn, statement, ...) : 
  RS-DBI driver: (error in statement: near "BETWEEN": syntax error)

But this works:

sql.conn <- dbConnect(dbDriver("SQLite"), "C:/.../lahman.sqlite")
dbGetQuery(sql.conn, "select * from AllstarFull WHERE yearID BETWEEN 1934 AND 1947")