Or a misunderstanding on your part on the goals of the project and reasons for them.
So just list the reasons, please. IMO there is no single reason to work with files stored on the server. It could be even considered non-safe in some scenarios. It's enough to work with client-side files. It's valid for local as well as remote work
I agree. Except where it is not possible to do so, or in cases where it could lead to an inconsistent UI experience.
What do you mean by inconsistent UI experience? If you mean pgadmin having different file browser appearance across various operating systems then it's non-relevant argument. Goal should be to have UI-consistent app in environment it's running under.
With client-app responsible for opening files approach, everything would work out together.