I think, when ID is not set, we can insert like INSERT INTO t (id, c, ...) VALUES (xx, c_val, ...)

where xx can be something like select max(id, seq.nextval) instead

note: As PK is unique, this should throw an duplicate PK now, thus not corrupt data.