Soft delete in Azure SQL without relying on fragile filters
If your app needs to hide data without actually dropping rows, Azure SQL now plays nicely with soft delete. That’s handy when you expose a database to an AI agent through something like SQL MCP Server, where mistakes need to be reversible. The catch is simple: filtering on a delete flag in every query is easy to mess up, and one missing filter leaks data.