Update database delete calls to better handle bulk deletion requests

Currently, we load all records before deleting records associated with a request to delete, which can be inefficient with large requests. To better handle this, we should update the HQL logic + generator to be able to handle DELETE queries without having to load data first.