Thanks Tess. I might've caused some confusion when I referenced "Table1" and "Table2" in the SQL of my post. These are not the real names of the database tables. I thought it would be less confusing to use these names rather than the actual table names in the database. I don't know why I didn't think about the fact that Retool uses thsoe names for the table components. I reworked my case using the actual names to remove this confusion (bold words). I'll do better next time I post a case.
My app is based on a Postgresql database view including two tables. Report has a series of columns, including URL. Serpstack has two columns: URL, pagetype. A user will be asked to go through a list of url's to determine the web page type. Serpstack has url's with some page types already assigned and other url's where the page type is yet to be determined. The view is roughly as follows:
SELECT a.url,
b.pagetype
from "Report" a
left join "Serpstack" b on a.url = b.url
where b.pagetype is null
As a user works the data by going to the url, identifying the appropriate page type and then editing the pagetype cell, I would like to either to do a bulk insert or single row insert into table 2. There would be fewer keystrokes required if I do a bulk insert. Is there a way to use the recordupdates array to complete the insert SQL? If bulk updates is not used, can I trigger an event to run the insert query each time I change a cell. Keep in mind that it looks like a cell change would require an UPDATE, but it actually requires an INSERT into Serpstack. When the view is refreshed, the record will no longer appear in the form table since the pagetype will be null. In subsequent apps, I will use the pagetype values once all the url records from Report have been processed.
INSERT INTO "Serpstack" (url, pagetype)
VALUES( )
The query below references "links". I don't know what that is. It also references what appears to be a table PageType which is not a database table I have. Maybe it's your test data. I thought this could be a query that Retool recognizes and, when I previewed it, I get an error message. I have a query like this in Retool that works with my database. I assume you just want me to use that?

Also, on your last screen shot, can you explain the transformer you used? I get that it is putting the contents of the recordupdates into the proper SQL syntax, but I don't understand why it references specific url's and product values. I assume that was the data you used. With that said, I don't want to create this line of code (from scratch) from each of the records in recordupdates. Did you execute some process that converted the recordupdates value into this line? Lastly, is bulk updates a safe way to update the database? For example, if the power goes off after entering changes to a large number of records, will the data be lost? If it is vulnerable, should I consider doing individual record inserts?