const query = db
.select({
// some fields
})
.from(leads)
.innerJoin(participants, eq(participants.id, leads.participantId))
.innerJoin(
organizations,
eq(organizations.id, participants.organizationId)
)
.innerJoin(campaigns, eq(campaigns.id, leads.campaignId))
.leftJoin(agents, eq(agents.id, leads.agentId))
.leftJoin(sites, eq(sites.id, leads.siteId))
.leftJoin(studies, eq(studies.id, leads.studyId))
.where((t) => {
// ... a bunch of conditions
})
.orderBy(desc(leads.updatedAt))
.$dynamic();
const query = db
.select({
// some fields
})
.from(leads)
.innerJoin(participants, eq(participants.id, leads.participantId))
.innerJoin(
organizations,
eq(organizations.id, participants.organizationId)
)
.innerJoin(campaigns, eq(campaigns.id, leads.campaignId))
.leftJoin(agents, eq(agents.id, leads.agentId))
.leftJoin(sites, eq(sites.id, leads.siteId))
.leftJoin(studies, eq(studies.id, leads.studyId))
.where((t) => {
// ... a bunch of conditions
})
.orderBy(desc(leads.updatedAt))
.$dynamic();