“We handle FKs in the app for flexibility.”
“And how many orphaned rows do you have?”
“…”
Not with that attitude: https://docs.postgrest.org/en/v13/index.html
Orphaned rows can very much matter for data privacy concerns, which is also where I most frequently see this approach failing.