K
Join ServerKysely
help
show generated sql
how can i see what the generated sql is for a kysely query? e.g.
result = await db.selectFrom("data")
.select(['partner_cd', 'reporter_cd', 'product_cd', 'period'])
.where((wb) =>
wb.where("reporter_cd", "=", region1).where("partner_cd", "=", region2),
)
.orWhere((wb) =>
wb.where("partner_cd", "=", region1).where("reporter_cd", "=", region2),
)
.execute()
Message Not Public
Sign In & Join Server To View
You can use
$call
method.const rows = await kysely
.selectFrom("user")
.select(["id", "last_name"])
.$call((qb) => {
console.log(qb.compile())
return qb
})
.execute()
Thank you both, I will try those