Update the CrudDeleteQuery to handle the new soft and hard modes.