Motivation
The familiarise_mobile backend's direction is ORM-first: typed delegates everywhere, no raw SQL / JsonQueryBuilder for new code (Practitionist/familiarise_mobile#106). The biggest missing capability vs Prisma TS is nested writes — e.g. creating a Consultation + Appointment + SlotOfAppointment rows currently requires a hand-rolled transaction with multiple delegate calls.
Scope
create(data: { ..., relation: { create: {...} } }) and connect: { id } for to-one and to-many relations- Same for
update (nested create/connect/disconnect)
- SQL strategy: multi-statement inside
executeInTransaction, ordered by FK dependencies from the SchemaRegistry relation metadata
- Generated input types: extend Create*Input with optional nested relation inputs (keep manual toJson approach from v0.5.4)
Motivation
The familiarise_mobile backend's direction is ORM-first: typed delegates everywhere, no raw SQL / JsonQueryBuilder for new code (Practitionist/familiarise_mobile#106). The biggest missing capability vs Prisma TS is nested writes — e.g. creating a Consultation + Appointment + SlotOfAppointment rows currently requires a hand-rolled transaction with multiple delegate calls.
Scope
create(data: { ..., relation: { create: {...} } })andconnect: { id }for to-one and to-many relationsupdate(nestedcreate/connect/disconnect)executeInTransaction, ordered by FK dependencies from the SchemaRegistry relation metadata