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.