{"id":43442,"library":"node-mysql-query-builder","title":"node-mysql-query-builder","description":"A simple MySQL query builder for Node.js, version 0.0.9. Provides basic CRUD operations with chaining syntax. Lightweight and zero-dependency. Note: very early release with limited features; not recommended for production use. No updates since initial release.","status":"abandoned","version":"0.0.9","language":"javascript","source_language":"en","source_url":"https://github.com/ddwwcruz/node-mysql-query-builder","tags":["javascript","mysql","typescript"],"install":[{"cmd":"npm install node-mysql-query-builder","lang":"bash","label":"npm"},{"cmd":"yarn add node-mysql-query-builder","lang":"bash","label":"yarn"},{"cmd":"pnpm add node-mysql-query-builder","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[{"note":"Default export only. Must use default import or require with .default.","wrong":"const { QueryBuilder } = require('node-mysql-query-builder')","symbol":"QueryBuilder","correct":"import QueryBuilder from 'node-mysql-query-builder'"},{"note":"Named export for raw SQL expressions.","wrong":"const raw = require('node-mysql-query-builder').raw","symbol":"raw","correct":"import { raw } from 'node-mysql-query-builder'"},{"note":"In CommonJS, .default access required because package uses ES modules.","wrong":"const QueryBuilder = require('node-mysql-query-builder')","symbol":"QueryBuilder (CommonJS)","correct":"const QueryBuilder = require('node-mysql-query-builder').default"}],"quickstart":{"code":"import QueryBuilder from 'node-mysql-query-builder';\nconst qb = new QueryBuilder('users');\nconst query = qb.select('id', 'name')\n  .where('active', '=', 1)\n  .build();\nconsole.log(query);\n// Output: SELECT id, name FROM users WHERE active = 1","lang":"typescript","description":"Demonstrates basic SELECT query with where clause, showing chaining and final build."},"warnings":[{"fix":"Use import or const QueryBuilder = require('node-mysql-query-builder').default","message":"Package uses ES modules; require() without .default returns an object, not the constructor.","severity":"gotcha","affected_versions":"0.0.9"},{"fix":"Always use parameterized queries via connection driver, or manually escape values.","message":"No built-in escaping for user input; SQL injection risk if used directly.","severity":"gotcha","affected_versions":"0.0.9"},{"fix":"Consider using Knex.js or Sequelize for production.","message":"Very limited features: no JOINs, subqueries, aggregations. Not suitable for complex queries.","severity":"gotcha","affected_versions":"0.0.9"},{"fix":"Install @types/node-mysql-query-builder or write your own type declarations.","message":"No type definitions included despite claiming TypeScript support; index.d.ts may be missing.","severity":"breaking","affected_versions":"0.0.9"}],"env_vars":null,"search_vec":"'0.0.9':14 'basic':16 'builder':5,10 'chain':20 'crud':17 'depend':26 'earli':29 'featur':33 'initi':42 'javascript':44 'lightweight':22 'limit':32 'mysql':3,8,45 'node':2 'node-mysql-query-build':1 'node.js':12 'note':27 'oper':18 'product':37 'provid':15 'queri':4,9 'recommend':35 'releas':30,43 'simpl':7 'sinc':41 'syntax':21 'typescript':46 'updat':40 'use':38 'version':13 'zero':25 'zero-depend':24","created_at":"2026-06-05T16:59:48.862687+00:00","updated_at":"2026-06-05T16:59:48.862687+00:00","problems":[{"fix":"Ensure installation: npm install node-mysql-query-builder. If missing, use a fork.","cause":"Package version 0.0.9 not published to npm? Check npm registry.","error":"Cannot find module 'node-mysql-query-builder'"},{"fix":"Use const QueryBuilder = require('node-mysql-query-builder').default","cause":"CommonJS require() without .default gives the module's exports object, not the class.","error":"TypeError: QueryBuilder is not a constructor"},{"fix":"Use import QueryBuilder from 'node-mysql-query-builder'","cause":"TypeScript uses ES module import; named import of 'QueryBuilder' is wrong because it's a default export.","error":"Property 'default' does not exist on type 'typeof import(...)'"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/ddwwcruz/node-mysql-query-builder#readme","github":"https://github.com/ddwwcruz/node-mysql-query-builder","docs":null,"changelog":null,"pypi":null,"npm":"node-mysql-query-builder","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}