Joins with results in arrays
const fetchedOrderServices = await tx
.select()
.from(orderServices)
.where(eq(orderServices.orderID, order))
const fetchedOrderLocalServices = await tx
.select()
.from(orderLocalServices)
.where(eq(orderLocalServices.orderID, order))
const [fetchedOrder] = await tx
.select()
.from(orders)
.where(eq(orders.orderID, order))
.leftJoin(rentCarBookings, eq(rentCarBookings.orderID, order)) const fetchedOrderServices = await tx
.select()
.from(orderServices)
.where(eq(orderServices.orderID, order))
const fetchedOrderLocalServices = await tx
.select()
.from(orderLocalServices)
.where(eq(orderLocalServices.orderID, order))
const [fetchedOrder] = await tx
.select()
.from(orders)
.where(eq(orders.orderID, order))
.leftJoin(rentCarBookings, eq(rentCarBookings.orderID, order))I would like a single select with joins that gives me more or less the same result. Something along the lines of:
{
fetchedOrder: {
orderID: OrderID,
customerID: CustomerID
},
localServices: {orderID: OrderID, localServiceID: LocalServiceID}[},
globalServices: {orderID: OrderID, globalServiceID: GlobalServiceID}[]
}{
fetchedOrder: {
orderID: OrderID,
customerID: CustomerID
},
localServices: {orderID: OrderID, localServiceID: LocalServiceID}[},
globalServices: {orderID: OrderID, globalServiceID: GlobalServiceID}[]
}