Kysely•17mo ago

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•17mo ago

Message Not Public

wirekang•17mo 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•17mo ago

Thank you both, I will try those

Gaming

Programming

show generated sql