Can my DB?

Use WITH (Common Table Expressions) in INSERT, UPDATE, or DELETE statements.

Return columns from rows removed by a DELETE statement.

Return columns from rows affected by an INSERT statement.

Conditionally INSERT, UPDATE, or DELETE rows in a target table based on a join with a source.

Update or delete rows in one table based on a join condition with another table.

Lock selected rows for the duration of a transaction to prevent concurrent modification.

Skip rows that are currently locked by another transaction, enabling efficient job queue patterns.

Remove all rows from a table without logging individual row deletions.

Update rows using data joined from another table.

Insert a row, or update an existing row when a key conflict occurs.