Insert returning and left join

Is it possible to do a leftJoin when returning() on an insert?

Pseudo code that do not work (but to show an example of what I want). I.e. I want the user object returned on each splits I insert.

  const [splits] = await db.insert(transactionSplitsTable).values(insert_splits).returning().leftJoin(usersTable, eq(usersTable.id, transactionSplitsTable.user_id)

  const [splits] = await db.insert(transactionSplitsTable).values(insert_splits).returning().leftJoin(usersTable, eq(usersTable.id, transactionSplitsTable.user_id)

  const [splits] = await db.insert(transactionSplitsTable).values(insert_splits).returning().leftJoin(usersTable, eq(usersTable.id, transactionSplitsTable.user_id)

  const [splits] = await db.insert(transactionSplitsTable).values(insert_splits).returning().leftJoin(usersTable, eq(usersTable.id, transactionSplitsTable.user_id)

Insert returning and left join

Similar Threads

Similar Threads

Similar Threads