ORM Design

A six-second NocoBase bulk update overwrote a row that had stopped matching the filter

The filter appears once, in the SELECT that collects primary keys, and the writes then go out one statement per row keyed on id. Anything that changes a row in between is overwritten, and the window grows with the row count.