Delete using pg query in drizzle - Drizzle Team

Drizzle Team•3y ago•

3 replies

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;