Update

Use update methods to modify existing rows.

update()

ballerina

var updated = check db.'from(User)
    .'where({id: {equals: 1}})
    .update({name: "Alice Smith"});

ballerina

int affected = check db.'from(User)
    .'where({status: {equals: "PENDING"}})
    .updateMany({status: "ACTIVE"});

ballerina

var result = check db.'from(User).upsert(
    {email: "alice@example.com", name: "Alice"},
    {name: "Alice Updated"}
);

upsert() currently returns sql:ExecutionResult|error.

Continue with Delete.