DELETE Statements

Basic DELETE

Remove records using delete with a filter:

delete User filter id = 1

-- Transpiled SQL
DELETE FROM User WHERE id = 1

Delete with Complex Filter

delete Session filter expired = true

-- Transpiled SQL
DELETE FROM Session WHERE expired = true

delete Order filter status = "cancelled"

-- Transpiled SQL
DELETE FROM Order WHERE status = 'cancelled'

Delete All Records

delete TempData

-- Transpiled SQL
DELETE FROM TempData

Safe Deletion Patterns

Always use a filter to avoid accidental data loss:

-- Delete specific record by ID
delete User filter id = 42

-- Delete old records
delete Log filter created_at < "2024-01-01"

-- Delete by status
delete Task filter completed = true