As far as I can tell, prisma has turned into just an open source typescript query builder (probably the best in it's class though). Prisma used to be graph.cool which was very similar to Hasura.
Sort of. They're capable of analytics, but Metabase is a Business Intelligence tool, and Posthog is focused on user interaction/website analytics.
They both give you incredibly useful data, but different kinds. Metabase lets you analyze trends/relationships in your overall database-layer data. Posthog lets you analyze how users are interacting with your website/app and where your traffic is coming from.