will joins in delete queries be supported?

example:

   await db
            .delete(orderSubline)
            .leftJoin(orderLine, eq(orderLine.id, orderSubline.orderLineId))
            .where(eq(orderLine.orderId, orderId))

   await db
            .delete(orderSubline)
            .leftJoin(orderLine, eq(orderLine.id, orderSubline.orderLineId))
            .where(eq(orderLine.orderId, orderId))

1 Reply

Mykhailo•8mo ago

Hello, @skelaw! As for now, joins are not available in a delete statement in Drizzle, but you can use the workaround with db.execute()

Gaming

Programming

will joins in delete queries be supported?