{"library":"sql-query-builder","type":"library","category":null,"description":"Qb is a JavaScript SQL query builder for Node.js that generates SQL from JSON objects instead of method chaining. Current stable version is 0.3.2. It builds on brianc/node-sql and supports PostgreSQL, MySQL, and SQLite. Key differentiator: designed for BI applications where non-technical users send JSON specifications via an API. It enforces security by only allowing defined tables/columns, supports automatic joins based on model associations, and provides context-aware aliases. The library is minimal and has no active releases since 2017, suggesting maintenance status.","language":"javascript","status":"maintenance","version":"0.3.2","tags":["javascript","query","BI","query builder","sql builder","sql","postgresql","postgres","mysql"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install sql-query-builder","imports":["import Qb from 'sql-query-builder'","const Qb = require('sql-query-builder')","const qb = new Qb(definitions, dialect); const sql = qb.query(spec);"]},{"cmd":"yarn add sql-query-builder","imports":[]},{"cmd":"pnpm add sql-query-builder","imports":[]}],"homepage":"https://github.com/jtschoonhoven/qb","github":"https://github.com/jtschoonhoven/qb","docs":null,"changelog":null,"pypi":null,"npm":"sql-query-builder","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}