Mapping a Column Value to a DB Columns Name

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?