Hi,
I'm trying to use a dplyr pipeline for querying data inside a mapd database.
My current problem with it is that mapd SQL is SQL-92 conformant, and thus, doesn't accept R basic != operator, only SQL-92 <>.
I made a request to mapd to support the != operator, but in the meantime, I was wondering if you know any way to automatically convert my != characters, generated with my dplyr's query, to <>.
Considering my code is in a dplyr pipeline, agnostic regarding the db hosting the data, I can't write the request, do some string manipulation (like a basic str_replace) and then send the request : it has to work on local data.frames too.
I was wondering if DBI/dbplyr allows to restrict the operators set, and thius, fix my problem.
I'm querying the db through RJDBC package (using JDBC driver).
Thanks for any idea