Mappings:

• Storage & Distribution
• Memberships
• Channels
• Videos
• Comments and reactions
• Video nfts
• Channel payouts (Channel payouts: Mappings, CLI, Integration-tests, TS lib joystream#4334, estimate: TBD)
• Direct channel payouts (Ephesus: add optional payment to member remark joystream#4517, estimate: 2h)

Misc:

• Orion V2: Simplify entity caching #54
• Deployment of Orion v2 to Subsquid Aquarium (this would allow easy, "one-click" deployment for anyone w/ a GitHub account, making it very useful for future gateway operators. Estimate: ~2-4h left)
• Issue w/ OR queries: Unexpected behavior of queries that include OR subsquid/squid-sdk#153

User mutations:

• Video views
• Channel follows
• Channel/video reporting

Operator mutations:

• Kill switch (Estimate: < 1h)
• Video hero (Estimate: 2h)
• Category featured videos (Estimate: 2h)
• Supported categories
• Content censoring on the Gateway level (Channel level filtering policy #55) (Estimate: 3h)

Queries:

• Filtering through views
• extendedChannels (channels + activeVideosCount)
• mostRecentChannels (Estimate: 3h)
• channelNftCollectors (Estimate: 3h)
• extendedVideoCategories (category + activeVideosCount) (Estimate: 3h)
• mostViewedVideosConnection

Operator queries: (Estimate: ~1-2 days, low priority)

• Video views
• Channel/video follows
• Channel/video reports

Subscriptions:

• State subscription

Documentation:

• Initial CHANGELOG.md (Orion v1 vs Orion v2)
• Developer guide
• Operator guide (Estimate: 4h)

Tests & benchmarks:

• Orion v2 / Orion v1 comparison tests and benchmarks #65 (Estimate: 4-5 days)