This took almost 2 days of research but no end as i am new to this prisma..
Findings:
I always thought that prisma is like an ORM(Object relational mapper similar to mongoose) but turns out prisma is super heavy (around 50-120MB) with just its engine modules.
Also this is not an ORM but a wrapper around few modules that gets things done.
Also if you only want simple features of create/fetch data then other heavy modules in server just doesn't make sense.
Overall major red flags for this in almost every tech blog i came across with.
PS: So decided to use less of prisma / eventually master prisma in a way that i can overcome its red flags.
Deployment is failing due to prisma and planetscale communication error due to existing table / migration.