K
Kysely•2y ago
kewp

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()
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()
3 Replies
Unknown User
Unknown User•2y ago
Message Not Public
Sign In & Join Server To View
wirekang
wirekang•2y ago
You can use $call method. 
const rows = await kysely
  .selectFrom("user")
  .select(["id", "last_name"])
  .$call((qb) => {
    console.log(qb.compile())
    return qb
  })
  .execute()
const rows = await kysely
  .selectFrom("user")
  .select(["id", "last_name"])
  .$call((qb) => {
    console.log(qb.compile())
    return qb
  })
  .execute()
kewp
kewpOP•2y ago
Thank you both, I will try those

Did you find this page helpful?