I am trying to figure out a way to do the equivalent of below command in phoenix:
update ics_tag_list set targetColumn = concat( 'prefix', sourceColumn) where rig =somerig;
I know that Phoenix does not support update command to update rows. But how do I update rows without entering values of all the columns in the query as an upsert command? Even with the upsert select command, we can only select values from other tables but I am not able to think of a way to generate the equivalent of above query in Phoenix since my source and target columns will change upon selection in the UI.