Hi Jay,
Thanks for the input! Unfortunately, in my use case, it's not the column name that relates to the DB field but the value in the column., think of it like a DB table displayed vertically rather than horizontally, so the DB field names are displayed down the left-hand side of the table rather than across the top row. So in the image, I attached I have a column value that says:
What CPU
In the DB, that field name is:
what_cpu
The value I want to be able to change in that field is AMD.
So using my image as an example the update SQL statement might look like:
UPDATE components SET (what_cpu = 'Intel', qty_of_ram = '128', what_gpu = 'AMD') WHERE....;
Hopefully, that makes the use case a little clearer.
Having just thought about it writing this out, perhaps there is a way of displaying a SQL table vertically instead of horizontally in Retool?