drizzle-team / drizzle-team/drizzle-orm

[FEATURE]: DELETE JOIN

Open
#3,100 2 comments 36 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.