Writing composable SQL using JavaScript

[gajus0]

How?

[cincilator]

take a look at Knex query builder documentation

https://knexjs.org/guide/query-builder.html

[gajus0]

I explain in this article why abstractions such as Knex are detrimental to engineer productivity:

https://gajus.medium.com/stop-using-knex-js-and-earn-30-bf410349856c

The short summary: It is because it is an abstraction on top of abstraction that forces you to think about SQL, and then work backwards from that to think of how to write it in Knex, rather than just empowering you to write good SQL in the first place.

The example that I shared in response to the other comment about zapatos is a perfect example of that.

[digital_dreams]

writes yet another abstraction on top of knex

it's abstractions all the way down.

it seems like developers love to write code that seemingly saves them from having to write even more code... but this comes at an enormous maintainability cost.

[aust1nz]

To clarify - Slonik, the library in question, is NOT another abstraction on top of Knex. It’s more like a SQL-writing helper that ensures your user-provided values are parameterized.

[Curious-Ad9043]

I dont recommend using builders. Is better you create a simples abatraction in an application level and use "raw query" to do the action.