Re:Writing Composable SQL Using Knex and Pipelines
by damidekronik on Thursday November 28, 2024 @01:04PM
(#42267328)
What's missing from https://kysely.dev/?
Re:Writing Composable SQL Using Knex and Pipelines
by mythz on Thursday November 28, 2024 @01:09PM
(#42267367)
Looks pretty good, but APIs look more stringly typed and APIs don't look natural, I prefer using SQL expressions with typed references.
The query builder also looks coupled to execution, litdb query builders and aren't coupled to a driver implementation, i.e. they're just used to generate SQL with parameters that could then be executed with any driver.
It's also highly composable as SQL expressions can be embedded within SQL Builders which can themselves be embedded within other Query Builders.
https://litdb.dev