UPDATE Support in BigQuery Connector – Is It Planned or Possible ?

[irimescucosmin]

Hi everyone,
I'm using Trino with the BigQuery connector and ran into a limitation: UPDATE statements aren’t currently supported. In many real-world use cases, we need to update just a few rows based on specific conditions — but without native UPDATE support, we’re forced to build workarounds that feel unnecessarily complex.

So far, I’ve tried using DELETE followed by INSERT, running update logic directly in BigQuery outside of Trino, or creating temporary tables to swap data. These approaches work, but they add extra steps and operational overhead.

I’m curious — is support for UPDATE in the BigQuery connector something that’s on the roadmap? Or is it a limitation on the BigQuery side itself that Trino can't overcome?
Also, if others here are dealing with the same constraint, how are you managing updates in practice?

Thanks a lot to the Trino team and community.