hello, just an idea--
if monetdb gets a flood of new R users over the next year, they might get thrown off by things breaking when they use a double-equals sign (example below).. sqlite accepts the double-equals as a single equals.
thanks
> dbGetQuery(db,'select count(distinct mycolumn) from mytable where yr=2003')
L1
1 334343
> dbGetQuery(db,'select count(distinct mycolumn) from mytable where yr==2003')
Error in .local(conn, statement, ...) :
Unable to execute statement 'select count(distinct mycolumn) from mytable where yr==2003'.
Server says 'syntax error, unexpected '=' in: "select count(distinct mycolumn) from mytable where yr=="' [#42000].
>