Proposal: Add dependent: :delete_async for associations

Hello Rails team :wave:

Related:

I wanted to start implementing this functionality immediately after seeing that I’m not the only one who needs something faster than destroy_async (see comments in Offer dependent: :destroy_async for associations by adrianna-chang-shopify · Pull Request #40157 · rails/rails · GitHub and Offer dependent: :destroy_async for associations by adrianna-chang-shopify · Pull Request #40157 · rails/rails · GitHub).

However, I decided to discuss this first to save implementation time. What are your thoughts on this functionality? Would it help mitigate pain points for a significant portion of the community (even if just a fraction)?