Subgraph for SporosDAO PM contract

[ivelin]

Problem

Currently we pull ProjectManagement transaction information via RPC, which is suboptimal.

The data views we pull such as list of project per DAO, list of tributes per project, are not indexed, which causes many RPC roundtrips. See for example getProjects.

Solution

One option is to build a subgraph that indexes the data and makes it efficient to access.
@nerderlyne developed a subgraph for Project Management under the Kali subgraph.
However there are some issues with it that we haven't resolved yet.

Ideally, the Kali subgraph will be updated on all supported EVM chains to include project management. However if it proves impractical to sync team roadmaps continuously, it may be more practical to maintain a separate hosted subgraph node for SporosDAO contracts.

[EdgeCaser]

Milestone :V future