help

show generated sql

K_kewp

5/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()

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 User

5/16/2023

Message Not Public

Wwirekang

5/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()

const rows = await kysely
  .selectFrom("user")
  .select(["id", "last_name"])
  .$call((qb) => {
    console.log(qb.compile())
    return qb
  })
  .execute()

K_kewp

5/16/2023

Thank you both, I will try those

Looking for more? Join the community!

help

help

Want results from more Discord servers?

Add your server

Recommended Posts

Property does not exist on typeHello. I'm trying to run the following query: ```javascript result = await db.selectFrom("data") Correct type definitions for function receiving builderI have something like this and I was wondering if it's the correct way to type my helper function. Transform Postgres array into JS arrayHey, I was wondering if there's a helper or something to transform Postgres arrays `{one, two}` into Noob Question: SQL INSERT that combines static values with a SELECT statementHey Kysely community! I'm just getting into Kysely and I have a question about how I could run the f Is there a way to execute an ExpressionBuilder?Using the expression hasDogNamed example from the docs ``` const eb = expressionBuilder<DB, 'person Argument of type 'string' is not assignable to parameter of type 'DynamicReferenceBuilder<never>'.The following statement, is giving me the error on the title ```ts fn("round", [fn.min("ld.price_btc How do Date columns works?I am learning Kysely from the website, at the getting started section I can see the following line: converting result.insertedId to numberwhen using INT as PK i can safe convert `result.insertedId` from `bigInt` to `Int` using `Number(res Advice on building plugin for working with parametersI am currently working on a driver for YDB https://github.com/Gaspero/kysely-ydb YDB dialect expect Mysql Query execution never endsHello, I have a question regarding my new integration of kysely in trpc. I wanted to port my prisma