SQLite supports LIMIT and ORDER BY in UPDATE queries.
LIMIT
ORDER BY
UPDATE
I'd be interested in looking into this