When working with databases in NestJS, one common challenge is managing column naming conventions—specifically converting camelCase in your code to snake_case in the database. Luckily, the solution doesn’t need to be custom code in most cases! 🚀

Here’s how to handle it effectively:

🔹 TypeORM: Use a NamingStrategy, like the popular typeorm-naming-strategies package. It automates the conversion of column and table names to snake_case.

import { SnakeNamingStrategy } from 'typeorm-naming-strategies';

const config = {
  namingStrategy: new SnakeNamingStrategy(),
  // Other TypeORM configs
};

🔹 Prisma: Simply use the @map directive in your schema to map camelCase fields to snake_case database columns.

model User {
  firstName String @map("first_name")
}

✨ Pro Tip: While you could build a custom NestJS pipe for this transformation, it's better to rely on your ORM for these mappings—it’s cleaner and more efficient. Let the ORM do the heavy lifting for database conventions! 🛠️

Have you faced similar challenges while working with ORMs in NestJS? Let me know how you handled them! 👇