I am facing the same issue in my app.

I think we can resolve this by

1. Create Instead of Trigger - Disable the Foreign key constraints, delete records from parent table.

2....