sql-query-builder

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.