mysql-dialect
Is a MySql Database ease query builder. Provides a MySql Query Builder. This version contains MySql CRUD operations. Each function returns a query string ready to use with a MySql connection provider like mysql2 Package.
CRUD operations examples supported:
const { SELECT, INSERT, DELETE, UPDATE, SELECTALL } = require("mysql-dialect");Getting started:
const { SELECT } = require("mysql-dialect");
//Return `SELECT user_name,email FROM users`
const query = SELECT("user_name,email).FROM("users").get();Use with mysql2:
//Find mysql2 configuration at own documentation.
const mysql = require("mysql2");
const pool = mysql.createPool(...);//Use a query string instead raw string.
const result = await pool.query(query);