{"library":"node-database-executor","title":"Node Database Executor","description":"A lightweight Node.js database query executor supporting both JSON-based queries (jsonQuery) and raw SQL queries. Version 2.4.24 is current stable, with frequent updates. It supports MySQL, MS SQL, PostgreSQL, and SQLite across multiple drivers (mysql, mssql, pg, sql.js). Key differentiator: provides a declarative JSON query language abstraction over raw SQL, reducing SQL injection risks and simplifying dynamic query building. Uses a promise-based API. Active development with regular releases.","language":"javascript","status":"active","last_verified":"Sat Apr 25","install":{"commands":["npm install node-database-executor"],"cli":null},"imports":["import { promise } from 'node-database-executor'","promise.executeQuery(config)","import { promise } from 'node-database-executor'; promise.executeQuery({query: jsonQueryObject})"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"import { promise } from 'node-database-executor';\n\nasync function run() {\n  const query = {\n    table: 'users',\n    select: ['id', 'name'],\n    where: { active: true }\n  };\n  const config = {\n    dbConfig: {\n      databaseType: 'mysql',\n      engine: 'InnoDB',\n      database: 'mydb',\n      host: 'localhost',\n      port: 3306,\n      user: 'root',\n      password: process.env.DB_PASS ?? '',\n      connectionLimit: 10,\n      acquireTimeout: 2000\n    },\n    query: query\n  };\n  try {\n    const result = await promise.executeQuery(config);\n    console.log(result);\n  } catch (err) {\n    console.error(err);\n  }\n}\nrun();","lang":"typescript","description":"Executes a JSON query against a MySQL database using promise API. Demonstrates query building and config setup.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}