plan to support Update/Insert/Delete ?

[csimplestring]

Hi, I found the README file said that:
Only read operations are supported, such as SHOW and SELECT.

Is there any plan to support Update/Insert/Delete?

Thanks in advance.

[nineinchnick]

A while ago, in #16, I added support for ExecContext and implemented methods of the Result interface. I only did this to support the USE statement. There are no tests for DML statements like INSERT, UPDATE and DELETE, so this statement in the README is correct. But you should try it, as it might not require any extra work.

Please let us know if it does work, but we can keep this issue open until we add proper tests.

[csimplestring]

@nineinchnick it works! and it does not require any extra work. Thanks!

[csimplestring]

@nineinchnick does it support transaction? I roughly walked thru the code and figure out this go-client is using TrinoDB REST API to implement the sql driver interface. So I think transaction is not supported due to the stateless in http's nature. But I am not 100% sure.

[nineinchnick]

Transaction statements should work, but we don't have tests for this.