Your opinion is based on what?
I am sorry if I come across as unfriendly, but the breath-taking speed from …
… to dishing out opinions and advice makes me question your motivation. Have you read any of the links posted in this thread?
Then again, three years ago you’ve asked for an updated architecture spec?
Re: Subgraph … the last alpha release was in 2017. The last commits I can see in the repositories is from 2021. I think it’s safe to say at this point that the project is abandoned.