Ramazan Comments - Answer Overflow

Ramazan

Explore posts from servers

TtRPC TTCTheo's Typesafe Cult DTDrizzle Team

•Created by Ramazan on 9/20/2023 in #help

Prepend raw fields with table/subquery name in rendered SQL

That doesn't quite work in my case, where the raw sql field is in a subquery/CTE and collides with the name of of another table/subquery/cte. You have to prefix it with the subquery/CTE name manually every time it's used or keep track of and use different names for every such field like .as("balances_date") and .as("transaction_date").

6 replies

DTDrizzle Team

•Created by binajmen on 8/7/2023 in #help

Is it possible to have nested values when doing a leftJoin?

You can do something like

export async function getLoansLJ(spaceId: string) { 
  return db
    .select({ …getTableColumns(loans), financialInstitution: getTableColumns(financialInstitutions) })
    .from(loans)
    .leftJoin(
      financialInstitutions,
      eq(financialInstitutions.id, loans.financialInstitutionId)
    )
    .where(eq(loans.spaceId, spaceId));
}

export async function getLoansLJ(spaceId: string) { 
  return db
    .select({ …getTableColumns(loans), financialInstitution: getTableColumns(financialInstitutions) })
    .from(loans)
    .leftJoin(
      financialInstitutions,
      eq(financialInstitutions.id, loans.financialInstitutionId)
    )
    .where(eq(loans.spaceId, spaceId));
}