Web3 companies are unique in that they all start as big data companies from day 1. Ethereum has 1B+ transactions and growing. All of this data needs to be indexed efficiently to build new use-cases on top of it. 
This isn’t typical for an average web2 product company.

We at Sesame Labs realized this very quickly.
1. No single blockchain API provider had all the data.
2. Some providers surprisingly had stale NFT ownership data.
3. Due to the need for more complex queries, we still had to build our own data stores and keep them in sync.

The complexity very quickly blows up as you add more chains and new use-cases. We’ve been able to build something fairly sophisticated by stitching together AWS Batch, SQL ,PostgreSQL, and custom logic for data invalidation. However, there’s still a long way to go.

These hard technical challenges will be the difference between success and failure for web3 companies. In web2, after decades of work, some of these infra solutions have been commoditized. Cloud Providers like AWS and GCP have really leveled the playing field.

This will take time in web3 and the blockchain providers will have to evolve significantly to get there. In the meantime, successful companies will be ones that can comfortably go up and down the stack to build the right user experience.

We’re building lot of this cool tech at  Sesame Labs. We are assembling a strong team of founding engineers. If interested, please DM me.

Sure, there are blockchain API providers that try to solve this problem. But none of them work out of the box. Companies have to build their own backend systems and data infrastructure that reads from these APIs and transforms it in a way that is more useful for their use-cases.