I have an entity StockItem, this contains multiple @ManyToOne relations. There is a view called StockItemStatus that summarises the many to one relations to a single value (e.g. list of stock changes to the current stock level).

However, in MikroORM I am unable to relate the view to the entity.

@Entity()
export class StockItem {
    @PrimaryKey()
    id: number;

    @OneToOne(() => StockItemStatus, status => status.stockItem, { eager: true })
    status: Ref<StockItemStatus>;

    ...
}

@Entity({ expression: 'select * from stock_item_status' })
export class StockItemStatus {
    @OneToOne(() => StockItem, {
        joinColumn: 'stock_item_id', // StockItemStatus.stockItemId
        inverseJoinColumn: 'id' // StockItem.Id,
    })
    stockItem: Ref<StockItem>;

    ...
}

This works for all operations apart from create where I get the following error: TypeError: Cannot read properties of undefined (reading 'match').

I need to do this as otherwise I have ~10 @Formula on the entity and it takes a while to load.

I am using NestJS and GraphQL and am open to otherwise to achieve this.

I also need to able to query the related properties, so using GQL field resolvers is not the solution. MikroORM needs to be aware of the relation.