Insert

Add a new row to a table.

Request

{
  "action": "insert",
  "table": "items",
  "data": {
    "name": "New Widget",
    "category_id": 3,
    "price": 24.99,
    "status": "draft"
  }
}

Fields

Field	Type	Required	Notes
`action`	string	yes	must be `"insert"`
`table`	string	yes	target table
`data`	object	yes	column value pairs to insert

Response

{
  "success": true,
  "data": 42,
  "rows_affected": 1
}

data is the auto increment ID of the newly inserted row (last_insert_id).

Behaviors

columns you dont have write access to should cause jsonderulo to start stripping for you and remove the naughty stuff from data. if theres nothing left after stripping you get an error (cant insert nothing lol)
system columns should be auto populated:
created_by set to your user ID
pinned_to set to your user ID (unless you have rwa permission and explicitly set it to someone else)
created_at handled by SQL defaults
if the table has auto generation rules configured (like auto generated codes or UUIDs) those should get applied automatically
you need write permission on the table. read only permission codes like r, rg and ro will give you a nice 403