UPSERT statement does not exist natively in a Relational Database. It is composed of INSERT statement and UPDATE statement statements. It updates the query or it creates a new one if it does not exist

INSERT INTO table_name (column1, column2, column3, ...)  
VALUES (value1, value2, value3, ...)  
ON CONFLICT (column1)  
DO UPDATE SET column2 = value2, column3 = value3  

Pasted image 20240411201455.png