query/update.md


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54


Update
back to query /// home
Modify existing rows in a table.
Request
{
  "action": "update",
  "table": "items",
  "data": {
    "price": 29.99,
    "status": "active"
  },
  "filter": {
    "column": "id",
    "op": "=",
    "value": 42
  }
}


Fields


Field
Type
Required
Notes


action
string
yes
must be "update"


table
string
yes
target table


data
object
yes
column value pairs to update


where
object
yes*
simple key value filter


filter
object
yes*
structured filter


*at least one of where or filter is required. you cant do an unfiltered update.
Response
{
  "success": true,
  "rows_affected": 1
}


Behaviors

a WHERE clause is mandatory. the server refuses to run an update without one. this is a safety thingy yk
columns you dont have write access to are silently stripped. warning is included if json derulo stripped for you
last_modified_by auto set to your user ID
last_modified_at is handled by sqls ON UPDATE trigger
ownership scoping applies: if you have rwo you can only update rows where pinned_to equals your user ID uness you have rwa. same deal with rwg for group scoping
limit is applied if set and capped to your max
auto generation rules apply on update too if configured for the update action