Exactly, this allows to write one INSERT statement and change the DEFAULTs with NULLs: ~~~ INSERT INTO t1 (a , b , c ) VALUES (10 , NULL , NULL) , (NULL , 20 , NULL) , (NULL , NULL , 30 ) ; ~~~ I didn't know about the "NOT NULL ON CONFLICT REPLACE" part. Thank you very much!