show generated sql

Kkewp5/16/2023
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()
UUUnknown User5/16/2023
Message Not Public
Sign In & Join Server To View
Wwirekang5/16/2023
You can use $call method.
const rows = await kysely
  .selectFrom("user")
  .select(["id", "last_name"])
  .$call((qb) => {
    console.log(qb.compile())
    return qb
  })
  .execute()
Kkewp5/16/2023
Thank you both, I will try those