Brandon (@flybayer) the creator of Blitz, gave me some helpful feedback for how to categorize these services.

• Databases: Postgres, Mongo, Fauna, Dynamo, etc.
• APIs (auto-generated and custom): Hasura, Nhost, AppSync, Nexus, Apollo.
• All-in-one services: Firebase, Userbase, Supabase, Amplify.
• Fullstack frameworks: Blitz and Redwood.
• DB clients/ORMs, which includes Prisma, TypeORM, etc.