DELETE

Currently, delete only supports for Spark 3.5+.

Delete with condition:

DELETE FROM users WHERE id = 4;

Delete all rows:

DELETE FROM users;