Swift Manage Data

Manage Data

INSERT, UPDATE, and DELETE statements live in queries/ alongside SELECT files. SQLiteNow generates typed params from named SQL parameters and notifies affected tables after generated write methods run.

queries/task/insertOne.sql
queries/task/completeById.sql
queries/task/deleteCompleted.sql

INSERT

INSERT INTO task (title, completed, created_at)
VALUES (:title, 0, :createdAt);

try await db.task.insertOne(
    TaskInsertOneParams(
        title: "Call patient",
        createdAt: "2026-05-05T12:00:00Z"
    )
)

UPDATE

UPDATE task
SET completed = 1
WHERE id = :id;

try await db.task.completeById(TaskCompleteByIdParams(id: taskId))

DELETE

DELETE FROM task
WHERE completed = 1;

try await db.task.deleteCompleted()

When all writes go through generated SQLiteNow methods, watchers are notified automatically. Use external table change reporting only for writes that bypass SQLiteNow generated methods.