Update multiple rows with different values in a single SQL query

This happens when you calculate a bunch of values on your program, and then want to save the to SQL.

Upsert is an option, but it fails if you have a NOT NULL column: Upsert with NOT NULL column

Bibliography: