References
DML

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)