Delete using pg query in drizzle

Hello guys, is there any way to implement following query in drizzle?
DELETE FROM CustomerVehiclePart AS a
USING CustomerVehicle AS b,
Vehicle AS c
WHERE a.CustomerVehicleID = b.CustomerVehicleID
AND b.VehicleID = c.VehicleID
AND b.CustomerID = $1
AND c.SessionID = $2;
DELETE FROM CustomerVehiclePart AS a
USING CustomerVehicle AS b,
Vehicle AS c
WHERE a.CustomerVehicleID = b.CustomerVehicleID
AND b.VehicleID = c.VehicleID
AND b.CustomerID = $1
AND c.SessionID = $2;
2 Replies
Andrii Sherman
Andrii Sherman13mo ago
not yet, but if you can create a feature request for that on GH we can track it and implement
Alex.dev
Alex.dev13mo ago
Hi @Andrew Sherman. I've created one https://github.com/drizzle-team/drizzle-orm/issues/793. Let me know if I should add more details. Thanks!
GitHub
Issues · drizzle-team/drizzle-orm
TypeScript ORM that feels like writing SQL. Contribute to drizzle-team/drizzle-orm development by creating an account on GitHub.