Topics

Kysely•4mo ago

Partial compile

Hello everyone, is it possible (somehow) to generate only part of the compiled query? I have an edge-case when want to use only part ("where" statement in my case) of the compiled query from kysely. Is there any short-way to do it? I definitely don't want to parse the result. Thanks Mike

3 Replies

Unknown User•4mo ago

Message Not Public

Sign In & Join Server To View

mike•4mo ago

looks interesting. thank you @subframe75361 , I also need to transform... select a.* from table as a to:

select
  a.column1 as "a.column1",
  a.column2 as "a.column2",
  a.column3 as "a.column3"
from
  table as a

select
  a.column1 as "a.column1",
  a.column2 as "a.column2",
  a.column3 as "a.column3"
from
  table as a

any idea...?

Unknown User•4mo ago

Message Not Public

Sign In & Join Server To View

1.4KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

Querying on jsonArrayFromHi. So i need to fetch posts with comments from a database that are written by a set group of author Why does `.stream()` return a single result when I pass in a `chunkSize` option ?I'm guessing it returns `chunkSize` mount of rows for each iteration, but shouldn't it be an array i Is there a way to keep full date precision?It appears that selecting dates from Postgresql loses some precision, which wreaks havoc with my pag How can I get total row count without blowing up types?I have a simple query function that is in charge of generating a list of ids so that it can be passe Is there a way to handle migrations with .sql files?I enjoy being able to control the specific queries in the migration files. To do this, I use postgra Postgres: Transaction not honouring previous queriesHi, I have a table with unique constraint on some columns. In a transaction, I am deleting all the How do I specify a MySQL index hint?Hi, I am trying to build the following query (as a CTE, as part of a larger query), but I can not wo question about transaction isolation levelI am not sure if the way I do queries with transaction with kysely is the right way. I would be glad case when column = another columnI have a semi-complex query, and I'm trying to use a case() that includes a when() where the two val Webstorm warning with multiple joins```ts const organizationsWithAdminUser = await db .selectFrom("organizations") .