I wondered something similar about sqldf, because at one point my brain just seemed to work better "in" SQL. The biggest issue I found was that sqldf was signi

I wondered something similar about sqldf, because at one point my brain just seemed to work better "in" SQL. The biggest issue I found was that sqldf was significantly slower than dplyr and other alternatives. I started trying to mess about with something I was calling sqldf2. Didn't get very far, but there is some perhaps somewhat useful benchmarking in the R script here: https://github.com/phillc73/sqldf2/blob/master/R/sqldf2.R https://github.com/phillc73/sqldf2/blob/master/R/sqldf2.R