Flexible solution for selecting translation for arbitrary connections

[hadley]

Need to verify which connection methods actually get used (I think just escaping, and the rest is just S3 dispatch) and then provide some lightweight way for users to select their own translation layer.

Maybe something like:

con <- custom_translation(jdbcConnection, "Oracle")

with arguments to override default quoting for identifiers and strings?

All methods would need to redispatch to wrapped object.

[hadley]

Alternatively could provide something like:

register_translation(class(con), "Oracle", identifier = "'", string = '"')

And have custom behaviour in sql_translate_env.default() that would call getS3method()

[ghost]

This issue was moved by hadley to tidyverse/dbplyr/issues/98.

[lock]

This old issue has been automatically locked. If you believe you have found a related problem, please file a new issue (with reprex) and link to this issue. https://reprex.tidyverse.org/