Ask HN: I'm Confused about using ORM with Front end Frameworks

SQL Server should do just fine. I use Vitess (MySQL hosted on PlanetScale) with Prisma for my Next app, https://debate.land. It works just fine with scale, but I have found myself turning to writing some raw SQL queries to optimize performance/run some nuanced aggregations that Prisma doesn't seem to have a way to handle. If I had to do it again, I'd probably use https://drizle.team. Seems to be a more performant ORM. But for getting started, either will suffice.

I rarely see SQL Server being used alongside Next.js. But Prisma is quite popular in js land. There's also DrizzleORM, which is still relatively new. I'd recommend spending some time exploring both to see what fits you best :)

https://orm.drizzle.team/docs/quick-start

https://www.prisma.io/docs/getting-started/quickstart

You can definitely use SQL Server for your JS project, but do note that the general web "culture" is different to .NET's. Most people here are running Open Source stuff like PostgreSQL and MySQL, you're likely to find guides assuming as much. In JS specifically, NoSQL tools like MongoDB are popular and good if they align with your use case.

Side note: this feels more like a Stack Overflow question than an Ask HN post.