Now Phoenix don not support where clause within upsert. I also think this function is very important that use frequency is highly.
Maybe the dialect looks like this: Upset into scheme.table_name set col=‘x’ where id=‘x’ This semantic to implement is easy in Phoenix, we just need once write rpc if where condition can hit rowKey
