Registry / database / node-mysql-query-builder

node-mysql-query-builder

library0.0.9jsnpmunverified

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.

database

npm install node-mysql-query-builder

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · NODE-MYSQL-QUERY-B

node-mysql-query-builder

databasejavascriptv0.0.9

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

QueryBuilder

✓ import QueryBuilder from 'node-mysql-query-builder'

✗ const { QueryBuilder } = require('node-mysql-query-builder')

Default export only. Must use default import or require with .default.

raw

✓ import { raw } from 'node-mysql-query-builder'

✗ const raw = require('node-mysql-query-builder').raw

Named export for raw SQL expressions.

QueryBuilder (CommonJS)

✓ const QueryBuilder = require('node-mysql-query-builder').default

✗ const QueryBuilder = require('node-mysql-query-builder')

In CommonJS, .default access required because package uses ES modules.

Demonstrates basic SELECT query with where clause, showing chaining and final build.

import QueryBuilder from 'node-mysql-query-builder'; const qb = new QueryBuilder('users'); const query = qb.select('id', 'name') .where('active', '=', 1) .build(); console.log(query); // Output: SELECT id, name FROM users WHERE active = 1

Debug

Known issues

gotchaPackage uses ES modules; require() without .default returns an object, not the constructor.

fix

Use import or const QueryBuilder = require('node-mysql-query-builder').default

affects: 0.0.9

gotchaNo built-in escaping for user input; SQL injection risk if used directly.

fix

Always use parameterized queries via connection driver, or manually escape values.

affects: 0.0.9

gotchaVery limited features: no JOINs, subqueries, aggregations. Not suitable for complex queries.

fix

Consider using Knex.js or Sequelize for production.

affects: 0.0.9

breakingNo type definitions included despite claiming TypeScript support; index.d.ts may be missing.

fix

Install @types/node-mysql-query-builder or write your own type declarations.

affects: 0.0.9

Errors

Common errors & fixes

Cannot find module 'node-mysql-query-builder'

Package version 0.0.9 not published to npm? Check npm registry.

fix

Ensure installation: npm install node-mysql-query-builder. If missing, use a fork.

TypeError: QueryBuilder is not a constructor

CommonJS require() without .default gives the module's exports object, not the class.

fix

Use const QueryBuilder = require('node-mysql-query-builder').default

Property 'default' does not exist on type 'typeof import(...)'

TypeScript uses ES module import; named import of 'QueryBuilder' is wrong because it's a default export.

fix

Use import QueryBuilder from 'node-mysql-query-builder'

Upgrade

Version history

0.0.9latest on npm

Audit

Dependencies

No dependency data recorded yet.

Agent activity

2 hits · last 30 days

node

Resources

githubhttps://github.com/ddwwcruz/node-mysql-query-builder ↗

packagenode-mysql-query-builder ↗

homepagehttps://github.com/ddwwcruz/node-mysql-query-builder#readme ↗