sqldf library R snippet error

Hi,

I'm using sqldf R package to do some SQL queries on data. But when I do the same on the KNIME R snippet it returns me an error.

Code looks like this: 

install.packages("sqldf")
library(sqldf)

knime.out<-sqldf("SELECT knime.in$"Var1" FROM knime.in")

Error looks like this Error: unexpected symbol in "knime.out<-sqldf("SELECT knime.in$"Var1"

 

Tnx in advance.

Hmm, I played around with this a bit and I think that sqldf doesn't support the "."s in variable names.  Anyways, just out of curiosity, why do you need to run SQL on on KNIME data tables?  I imagine our column filters, row filters, groupby node and joiners should do the same thing, no?

Aaron