My personal preference is to either have a "deleted_at" column so deletes never need to happen, or have a "history" table. When this isn't possible, I do a sel

My personal preference is to either have a "deleted_at" column so deletes never need to happen, or have a "history" table. When this isn't possible, I do a select for the PK and delete based upon only the PK. This way I can review the rows to be deleted and back them up manually if needed. All of this is way overkill considering the backups available these days.