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))

Mykhailo•2/22/24, 1:09 PM

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