gistfile1.txt

UPDATE kv_table
SET value = (
  SELECT json_object(
    'user_id', json_extract(b.value, '$.user_id'),
    'user_uuid', json_extract(b.value, '$.user_uuid'),
    'workspace_id', json_extract(b.value, '$.user_workspace.id')
  )
  FROM kv_table AS b
  WHERE b.key = 'session_cache_key_backup'
)
WHERE key IN ('appflowy_session_cache', 'anon_user');