Hello @AlexRapsomanikis,
I just checked and it seems that this feature request had been moved to our engineering team's backlog.
However, it was recently moved to a new specialized 'resource auth' team from our core data team, which gives me hope that this will be but on their roadmap.
I also just added in your +1 to the ticket's thread which will give it more weight in being prioritized. I appreciate your patients on this as we work to build out a robust solution that will both meet security standards and also enable teams to develop without having to spend too much time authing and re-authing in to use resources.
I had a thread from another user where they use Oath 2.0 to give permission to an app as opposed to an app user which helped them set up their auth flow set up.
Might be worth checking out, although their solution is for a Microsoft service.