I believe expressions can be used as update values. For example, these queries works:

You say that "LIKE" limitation could be addressed with capabilities. How can I disable "LIKE" capability for update or delete statements?

is there anything else I should do regarding this jira?

Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector ---------------------------------------------------------------------------- Key: TEIID-3216 URL: https://issues.jboss.org/browse/TEIID-3216 Project: Teiid Issue Type: Enhancement Components: Misc. Connectors Reporter: Filip Elias Assignee: Filip Elias Fix For: 8.10 Current plan is to use list-based feed of the Google Data API[1]. There are three known issues: performance - to delete/update 100 rows Teiid must generate 100 http requests consistency - user wants to update 50 rows. After the 10th row is updated the connection could fail which would cause that 10 rows would be updated and 40 wouldn't. headers - update, delete and and insert statements will be supported only for the spreadsheets that have a header for each column (headers are in the first row of a spreadsheet) Select statement is implemented using Google Visualisation API, but this API doesn't support updates and doesn't return row numbers. [1] https://developers.google.com/google-apps/spreadsheets/