drizzle-team / drizzle-team/drizzle-orm
[FEATURE]: DELETE JOIN
Open
db/mysql
enhancement
qb/crud
- Dominant language
- TypeScript
- Stars
- 35.8k
- Forks
- 1.6k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 4
Description
### Describe what you want
```sql
DELETE TABLE1
FROM TABLE1
LEFT JOIN TABLE2 ON TABLE2.id = TABLE1.table2Id
WHERE
TABLE1.something IS NOT NULL AND
TABLE2.somethingElse IS NULL
```
```typescript
db
.delete(TABLE1, ....)
.leftJoin(TABLE2, eq(TABLE2.id, TABLE1.table2Id))
.where(
and(
isNotNull(TABLE1.something),
isNull(TABLE2.somethingElse),
)
);
```
Currently I use ``db.execute(sql`DELETE ...`)`` as a workaround
Contributor guide
Assessment
This issue has not been assessed yet.