Re:Writing Composable SQL Using Knex and Pipelines
by weeksie on Thursday November 28, 2024 @02:25PM
(#42267922)
1. You certainly need to know SQL
2. Composition is very different than concatenation and the differences become apparent as a project increases in complexity
3. I'd recommend checking out the current SOTA, especially with kysely (or Ecto if you ever get into Elixir projects)
[ Parent
| on HN ]
Re:Writing Composable SQL Using Knex and Pipelines
by hn_throwaway_99 on Thursday November 28, 2024 @02:47PM
(#42268080)
I've used kysely extensively on a project built using sst.dev. I can't paste proprietary code, but I remember my head spinning over a particularly gnarly query (e.g. a bunch of window functions, aggregations, etc.) It was a million times more difficult to grok reading this in kysely's syntax than SQL.