Database Soft Delete Implementation

Implement soft delete for these tables:

**Tables:**
```sql
{{TABLE_SCHEMA}}
```

**Requirements:**
- Retention period: {{RETENTION}}
- Recovery needs: {{RECOVERY_NEEDS}}
- Audit requirements: {{AUDIT}}

**Database System:** {{DATABASE_SYSTEM}}
**ORM/Framework:** {{ORM}}

Please provide:
1. Schema modifications for soft delete
2. DELETE query rewrites
3. SELECT query modifications (exclude soft-deleted)
4. Index adjustments
5. View for hiding soft-deleted records
6. Cascading soft delete for related records
7. Recovery/restore procedures
8. Permanent deletion (purge) process
9. ORM configuration
10. Migration from hard delete
11. Performance considerations