Back to Prompts

Full SQL to ORM Migration (Prisma/TypeORM)

Transform raw SQL queries across a codebase into ORM equivalents.

category:modernization

0

Prompt

This playbook is ideal when gradually migrating from manual SQL to a type-safe ORM such as Prisma or TypeORM.

## Steps:

1. Search the codebase for direct SQL usage (query builders, driver calls).

2. Define ORM models/entities that match the existing database schema.

3. Replace read-only SELECT queries with ORM find/findMany equivalents.

4. Refactor INSERT/UPDATE/DELETE operations to ORM create/update/delete.

5. Introduce transactions for multi-step operations that must be atomic.

6. Add integration tests verifying behavior for critical data flows.

7. Remove obsolete SQL helper utilities once all usages are migrated.

Related Prompts

Update Gradle build for Spring Boot 3

Update build.gradle with Spring Boot 3 plugin and Jakarta EE compatible dependencies.

spring-bootgradlebuild+4

Update Maven dependencies for Spring Boot 3

Update pom.xml with Spring Boot 3 dependencies and Jakarta EE compatible libraries.

spring-bootmavenbuild+4

Verify Spring Boot 3 dependency compatibility

Check and verify all third-party dependencies are compatible with Spring Boot 3.

spring-boottestingverification+5

Create Spring Boot 3 migration test suite

Generate comprehensive test cases to verify Spring Boot 2→3 migration success.

spring-boottestingtest+4

Update JPA entity mappings for Hibernate 6

Update JPA entity mappings and annotations for Hibernate 6 compatibility.

spring-boothibernatejpa+6

Fix Hibernate 6 JPQL query parsing issues

Resolve Hibernate 6 stricter JPQL query parsing errors and update query syntax.

spring-boothibernatejpa+6

Browse More Prompts