With Dynamic SQL Queries on TypeScript & NodeJS

#typescript #sql #webdev #javascript

Hello,
In this article, I will show you how to write a more dynamic, fast and sustainable SQL queries with @ssibrahimbas/query package, which is the npm package I wrote with my own keyboard.

This package creates you SQL queries. But it doesn't run them. We usually use ready-made SQL clients (like sequelize, pg) to run SQL queries in NodeJS. I developed this package only as a query-builder by making use of the Single Responsibility pattern. It's the job of sequelize or pg to execute the query. Whichever you want!

Let's install the npm package

npm install @ssibrahimbas/query

for yarn yarn add @ssibrahimbas/query

Okey, now let's create an index.js file and code it

const { Query } = require("@ssibrahimbas/query");

console.log(
  Query.table("users").select("id", "name").where("id", "=", 1).getAll()
);

The process here is to create the query that returns the id and name field if id 1 from the users table.

When we run the code we will get the following result:
SELECT id FROM users WHERE id = '1'

Better install a driver and give it a try on the real database! It was developed entirely with TypeScript, full support for TypeScript & JavaScript and has +50 unit tests. And the documentation is pretty good too!

I would be grateful if you share your experiences as comments.

Npm Package