News for hackers. Stuff that matters.

A comment on Writing Composable SQL Using Knex and Pipelines. Parent comment

Re:Writing Composable SQL Using Knex and Pipelines by thrw42A8N on Thursday November 28, 2024 @11:59AM (#42266805)
I have never had any issues like this, and the type safety provided by Kysely has saved me a lot of bugs and potentially very serious issues.
[ Parent | on HN ]
Re:Writing Composable SQL Using Knex and Pipelines by plopz on Thursday November 28, 2024 @12:31PM (#42267083)
I've had issues when needing to use sql functions.
[ Parent | on HN ]
Re:Writing Composable SQL Using Knex and Pipelines by thrw42A8N on Thursday November 28, 2024 @12:33PM (#42267101)
What issue? Kysely has an example to do this.
[ Parent | on HN ]
Re:Writing Composable SQL Using Knex and Pipelines by plopz on Thursday November 28, 2024 @01:47PM (#42267629)
This was one of the problems I ran into https://github.com/kysely-org/kysely/issues/664, not being able to use functions inside onDuplicateKeyUpdate
[ Parent | on HN ]
Re:Writing Composable SQL Using Knex and Pipelines by thrw42A8N on Thursday November 28, 2024 @01:50PM (#42267648)
Basically no ORM supports such specific functionality of a specific DBMS. In any case you'd have to use raw SQL. I don't see the problem, this is expected.

I don't see how not using Kysely would make it better overall - you simply write the raw SQL yourself as you would without it; but you gain so much type safety by using it.

[ Parent | on HN ]