What are Mutations? 🤔

A mutation refers to a change made to data stored in a database. Several commands are provided for data manipulation, such as INSERT (adds new records), UPDATE (modifies existing records), and DELETE (deletes records).

This support has limitations:

  • Only one data mutation (DELETE or UPDATE) at a given moment is possible. Trying to run another one will fail.

  • Data mutations rewrite all files containing the data from the UPDATE/DELETE condition. Running DELETE from the table without any condition is possible, but it will be much slower than the DROP TABLE table.

  • The syntax is simplified in comparison to Postgres. For example, the SET column=<value> operation doesn’t support sub-SELECT as the value, and the WHERE clause cannot contain sub-SELECT.

Currently, Oxla supports the following SQL mutations: