My table of items looks like this.

I am writing a delete API which deletes an item and should update the positions of the remaining items so there are no gaps. For example, after I delete ball, I would like the table to look like

In other words - it should delete the target item and reduce the position of all the items with positions greater than that of the target item by one.

Below is the way I am currently doing it -

-- GetItem: one
SELECT * from items WHERE id=?;
-- name: DeleteItem:execrows
DELETE FROM items WHERE id = ?;
-- name: UpdatePositions: execrows
UPDATE items SET position = position - 1
WHERE item.position > sqlc.arg(position);

And calling the functions shown -

item, _ := GetItem(id)
_, _ := DeleteItem(id)
_, _ := UpdatePositions(item.position)

I am first getting the item to be deleted to get its position, deleting the item, and executing an update command with the position found in the first step. I want to reduce the function calls I make for this delete operation.

Questions -

1. Can I execute the DELETE and UPDATE commands using a single generated function? So, execute two SQL statements with one generated function?
2. Can I omit the GetItem call by writing a single SQL statement to get and update item positions?