Implement Conditional Delete

[rahul1]

User Driven: https://discord.com/channels/905144809105260605/1146114778239078501/1146114778239078501

Use Case

When testing on localhost / a developer project, users often want to "reset" their project by clearing out groups of resources. Currently, the only way to do this is to query all the resources to get their IDs, and then to create a batch request to delete each resource individuall

Proposal

The FHIR spec allows for deleting all resources according to a search query, known as conditional delete

[codyebberson]

This is a good feature request.

The trick will be finding a way to do it performantly. In theory, it should be as simple as DELETE FROM "Patient" WHERE [...], but we do soft deletes and maintain the history table, so this will be O(n) queries :/