I wish to run the following sql statement within sqldf():
select columnA, "new_column_value" as columnB, "column.C" from mytable
where columnA in ('123','456')
but when I run within sqldf :
sqldf('select columnA, "new_column_value" as columnB, "column.C" from mytable
where columnA in ('123','456')')
I get the obvious error that the single quotes have escaped the sql code at in('123','456'), and if I wrap the sql code with double quotes, the sql is escaped where I create a new column "new_column_value" or when I select via literal string from the unhelpfully named "column.C".
So I am in a bit of a catch 22. It's almost as if I want to wrap by sql code in something other than quotes within the sqldf() call.
Can I escape both single and double quotes where I please?