Does TypeORM supports raw SQL queries for input and output?

orm typeorm
Roel picture Roel · Jun 12, 2017 · Viewed 34.4k times · Source

I would like to know if there is a feature of TypeORM that supports raw sql queries for Insert Update Delete Select etc..

Answer

Roel picture Roel · Jun 12, 2017

According to this issue comment, TypeORM enables you to use any queries to your heart's content. using entityManager.query() Here is the documentation.

UPDATE

Link above is outdated, try this instead entity-manager-api.

const rawData = await manager.query(`SELECT * FROM USERS`);

Related questions

TypeORM: update item and return it

As far as I know, it's a best practice to return an item after it has been updated. TypeORM's updateById returns void, not the updated item though. My question: Is it possible to update and return the modified item in …

Read More
How to save relation in @ManyToMany in typeORM

There are 2 entities named Article and Classification. And the relation of them is @ManyToMany. Here's my question: How to save the relation? My code as below: @Entity() export class Article { @PrimaryGeneratedColumn() id: number; @Column() name: string; @CreateDateColumn() createTime: Date; @UpdateDateColumn() …

Read More
How to fix the Hibernate "object references an unsaved transient instance - save the transient instance before flushing" error

I receive following error when I save the object using Hibernate object references an unsaved transient instance - save the transient instance before flushing

Read More