Delete Keywords

This page lists the SQL keywords and clauses used in DELETE statements, along with their corresponding methods in ts-sql-query. It includes support for joins, conditional filters, returning deleted rows, and database-specific features like USING or RETURNING INTO.

SQL Keyword	ts-sql-query Equivalent	Notes	Link
DELETE FROM	connection .deleteFrom(...)	Starts a delete statement for a given table.	Delete, Delete API
FROM	query .from(...)	Used to perform deletes with joins (SQL Server, PostgreSQL, MySQL).	Delete using other tables or views, Delete API
INNER JOIN	query .innerJoin(...)	Inner join between tables.	Delete using other tables or views, Delete API
JOIN	query .join(...)	Inner join between tables.	Delete using other tables or views, Delete API
LIMIT	Not supported yet. Use a custom SQL fragment.	Restricts the number of rows that are deleted.	Customizing a delete
LEFT JOIN	query .leftJoin(...)	Left outer join between tables.	Delete API
LEFT OUTER JOIN	query .leftOuterJoin(...)	Left outer join between tables.	Delete API
OUTPUT	query .returning(...)	Returns deleted rows or specific columns (SQL Server).	Delete returning, Delete API
RETURNING	query .returning(...)	Returns deleted rows or specific columns.	Delete returning, Delete API
RETURNING INTO	query .returning(...)	Returns deleted rows or specific columns (Oracle).	Delete returning, Delete API
TOP	Not supported yet. Use a custom SQL fragment.	Restricts the number of rows that are deleted.	Customizing a delete
USING	query .using(...)	Deletes using data from another table.	Delete using other tables or views, Delete API
WHERE	query .where(...)	Filters which rows should be deleted.	Delete, Delete API
WITH	query .forUseInQueryAs(...)	Common Table Expression (CTE) before DELETE.	CTE usage
WITH RECURSIVE	query .forUseInQueryAs(...)	Recursive Common Table Expression before DELETE.	Recursive select