{"library":"mysql-qbuilder","type":"library","category":null,"description":"Query builder for MySQL databases in Node.js, providing a fluent interface for constructing SQL queries including SELECT, INSERT, UPDATE, DELETE, JOIN, WHERE conditions, ORDER BY, GROUP BY, LIMIT, and OFFSET. Current stable version is 1.6.1, last updated in 2018. Connects using the mysql module and protects against SQL injection. Key differentiators: simple API, supports chaining, and provides query model methods like add, getFirst, getLast, getAll, findById, findFields. However, the package appears unmaintained with no recent updates, and relies on outdated Node.js engine requirements (>= 6.0.0).","language":"javascript","status":"maintenance","version":"1.6.1","tags":["javascript","query","query-builder","sql","mysql","builder","mysql-query-builder","mysql-qbuilder"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install mysql-qbuilder","imports":["const qBuilder = require('mysql-qbuilder')","qBuilder.setOptions({ hostname: '...', username: '...', password: '...', database: '...' })","qBuilder.makeQuery().select('*').from('table')"]},{"cmd":"yarn add mysql-qbuilder","imports":[]},{"cmd":"pnpm add mysql-qbuilder","imports":[]}],"homepage":"https://github.com/evelikov92/mysql-qbuilder#readme","github":"https://github.com/evelikov92/mysql-qbuilder","docs":null,"changelog":null,"pypi":null,"npm":"mysql-qbuilder","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}