I first learned about Knex.js from a technical interview, it was the first time I used another abstraction to interact with the database besides ORM Sequelize.js, which I learned during my study at the Grace Hopper program. Knex.js is an SQL query builder for JavaScript, a thin abstraction that sits on top of the database driver for relational databases including PostgreSQL, MySQL, SQLite2 and Oracle. It supports transactions, connection pooling, streaming queries, a thorough test suite, and the ability to run in the browser. Knex can be used in both Node.Js and the browser, limited only by WebSQL’s constraints.
Source: https://loowang28.medium.com/use-sql-query-builder-knex-js-with-node-js-and-express-js-4373e8d3ed33
