PostgreSQL UPDATE with LIMIT requires subquery pattern

PostgreSQL does not support LIMIT directly in UPDATE statements. When implementing batch updates (e.g., promoting memory events from short-term to long-term with a batch cap), you need a subquery pattern.