Support running copy_to() without transactions

[krlmlr]

Nested transactions currently don't work with ODBC (perhaps related to r-dbi/odbc#272). Also, not all databases support them.

It would be great if dbplyr supported a scenario where the caller is responsible for opening and committing a transaction.