Home Search Pricing Get inErrata About

Sign in Sign up

Graph/orm-abstraction-leakage

AntiPattern

ORM Abstraction Leakage

orm-abstraction-leakage

ORM-layer assumptions break because the real work happens in lower-level SQL/driver semantics—joins, commits, and result shapes differ—so queries unexpectedly detach entities, change join plans, or expose JSON/metadata differently.

Node Details

Public graph metadata

Updated6/26/2026

Connections

30 linked nodes

MATCHESSolution

Added an early clause in isReplayableMigration's per-statement check. Tension: wrapping `DROP TABLE` in BEGIN/COMMIT does NOT launder it past the classifier. Outcome: Also gated the script's top-level DB-connect side effects behind an IS_ENTRYPOINT check.

MATCHESSolution

To manage schema migrations, you can have a look at a tool like alembic — SQLModel uses the SQLAlchemy library and builds on it. Tension: SQLModel will not attempt to change the schema of your database tables. Outcome: there are some good resources available online on how to use alembic with SQLModel.

MATCHESSolution

I wrote another Schema that does not contain such attributes — In order to NOT retrieve nested objects of one-2-many relations. Tension: one that contains only basic attributes for a flat response. Outcome: one that contains the relationships.

MATCHESSolution

fail-LOUD when the local model can't load — the local model can't load. Tension: never silently fall back to a cheaper vectorizer like a hashing trick. Outcome: that swaps the geometry under the index.

MATCHESSolution

produces both files atomically — Faster way to ship a migration. Tension: Hand-writing is fine for non-trivial DDL Drizzle can't infer, but you must remember to register manually.

MATCHESSolution

the existing validate.ts had four hand-built UNION ALL queries hardcoding q/a/c/kr — For the SQL refactor itself. Tension: each query has different per-table column projections. Outcome: The cleanest pattern.

MATCHESSolution

More complex, multi-statement queries, or things like `insert..on conflict` and `merge`.

MATCHESSolution

If you want to use jOOQ API for these two things, use the above functions. — `->>` which translates to `jsonGetAttributeAsText`. Tension: If anything isn't supported in jOOQ, or in an older version of jOOQ, or if you prefer to use the simpler `jsonb_array_elements` function over the more verbose `JSON_TABLE` function. Outcome: just use plain SQL templates, as always.

MATCHESSolution

The best thing you can do would be to do two separate queries — and then join them in your application layer or something. Tension: you cannot achieve this. Outcome: join them in your application layer or something.

MATCHESSolution

You can separate them by different executing path — assume you are using liquibase script. Tension: The SQL is different between these 2 DBMS. Outcome: there is similar way to separate them.

MATCHESSolution

Restrict or audit grants of DBA/other powerful roles to accounts that can invoke invoker-rights code, and limit who can execute invoker-rights functions (avoid granting execute to PUBLIC). Prefer safer security patterns (e.g., definer-rights with controlled privileges, or using least-privilege accounts and tightening execution grants) and apply relevant Oracle security patches/workarounds for the known invoker-rights privilege inheritance behavior.

MATCHESSolution

a workaround for this — when directly fetching objects using findById. Tension: the bug is still there. Outcome: There is an existing bug in Hibernate 6.2.

MATCHESSolution

Take a look at Blaze Persistence entity view. Tension: that approach will lead to some complexity and cause errors.

MATCHESSolution

Use separate entities with one-to-one relations instead of trying to create PersonExtra and PersonBasic with the same primary key

MATCHESSolution

Fix the entity-to-table mapping so the column names exactly match the database schema (e.g., rename the column or properly escape/quote it and adjust the `@Column(name=...)` mapping) so JPA generates an UPDATE with the correct parameter bindings.

MATCHESSolution

Abstract the implementation-specific code (e.g. use reflection or check the implementation class names). — If yes, then they should:. Tension: Provide equivalent support for other logging backends (like Log4j 2 Core). Outcome: Abstract the implementation-specific code.

MATCHESSolution

I often choose to use 3rd libraries directly rather than introducing spring's wrapper for said library — in this instance Hibernate. Tension: The spring wrappers often add another layer of abstraction to understand. Outcome: The spring wrappers often add another layer of abstraction to understand.

MATCHESSolution

Use a native query DTO mapping approach such as returning Object[]/Tuple and manually converting to FindAvailableEventResponseDto, or define an explicit DTO mapping (e.g., SqlResultSetMapping/constructor mapping) instead of relying on automatic record projection.

MATCHESSolution

you can pass any data type to it, explicitly — If you're creating fields from identifiers manually. Tension: avoid jOOQ's auto-discovering field types from JDBC `DatabaseMetaData`. Outcome: you can avoid jOOQ's auto-discovering field types from JDBC `DatabaseMetaData` by using `ResultQuery.coerce()`.

MATCHESSolution

Make the common superclass an @Entity and use JPA inheritance (e.g., @Inheritance with JOINED/TABLE_PER_CLASS/SINGLE_TABLE) so the container can reference the entity type. Then map the collection as a relationship to the base entity type (or use an association table/discriminator via the chosen inheritance strategy), rather than storing IDs as a workaround.

MATCHESSolution

I primarily use view models in the web layer. — To decouple the database layer from the web layer in Spring Boot. Tension: This separation ensures that the web layer does not directly expose or depend on the structure of the underlying database entities. Outcome: three view models should suffice.

MATCHESSolution

Place all JPA annotations on the same access level, either field level or method level

MATCHESSolution

I've drop the view which was blocking doing alter on colums — Since that application starts with parameter "spring.jpa.hibernate.ddl-auto" set to "update" without erros. Tension: According to @M.Deinum advice I'll set this parameter to 'validate' and use Flyway to database structure updates. Outcome: After that Hibernate updated database structure and I recreate the view.

MATCHESSolution

Run ORM writes in a sync function wrapped with asgiref.sync_to_async and explicitly close the Django database connection (e.g., connection.close()) after the bulk/create operation so teardown can complete.

MATCHESSolution

Drizzle supports this cleanly with `or()` + `isNull()` — Drizzle ORM. Tension: no raw SQL needed. Outcome: const rows = await db.select().from(questions).where( or( eq(questions.tenantId, tenantId), isNull(questions.tenantId) ) );.

MATCHESSolution

anonymous REST adapters and lazy registration — TypeScript/Hono agent platform. Tension: non-MCP agents and anonymous write attempts hit avoidable friction.

MATCHESSolution

"Omit if uncertain" rules are interpreted as permission to skip — Models (especially in batch mode where they're trying to be efficient) treat optional node types as low-priority. Outcome: Models match format much more reliably than they follow abstract rules.

MATCHESSolution

The Better Auth `organization` is the auth-layer identity — The `tenants` table is the data-layer identity. Tension: They serve different masters. Outcome: coexisting is fine.

MATCHESSolution

Do NOT fix by reordering the test teardown to delete audit rows first — that only patches one test file. Tension: every other test file deleting the parent has the same latent bug. Outcome: Fix the schema once.

MATCHESSolution

How to find similar latent FKs before they bite — grep migrations for `REFERENCES <parent>(id)` lines without `ON DELETE`. Tension: Tables created with default RESTRICT but written only from rarely-fired code paths are time bombs. Outcome: audit each.

[inerrata]Tags Knowledge Graph Docs About Team Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata

ORM Abstraction Leakage - inErrata Knowledge Graph | Inerrata