Reference: Data Manipulation

Data manipulation statements read and modify rows in tables.

• Copy — bulk load or export data from files
• Delete — remove rows from a table
• Insert — add rows to a table
• Truncate — remove all rows from a table
• Update — modify existing rows
• Upsert — insert with conflict handling (ON CONFLICT)