Is there a way to add default values to a column in this scenario?
I want to get the updated values from some columns but then hard code some other values for particular columns.
Thanks
There might be a more elegant one-liner to do this right in your query, but I usually create a transformer that does this. Google something like Adding a property all object in an array and you will get some good direction.
I am trying to use this to update a table which is using a join in my query. However 0 I only need to update on column from one table, so I thought the .pick code might work: