{"library":"sql-json-generator","type":"library","category":null,"description":"sql-json-generator (v0.15.1) is a Node.js module that generates SQL queries (SELECT, INSERT, UPDATE, DELETE) from JSON objects, loosely based on MongoDB query syntax. It supports MySQL features like backtick escaping, aggregate functions, joins, subqueries via $raw, and SqlCalcFoundRows. The library is designed to simplify building reusable JSON query definitions for REST APIs with MySQL backends. It is not ESM-native and relies on CommonJS. Updates are infrequent; the last release was in 2021. Compared to alternatives like knex.js or sequelize, it is more lightweight but lacks ORM features and broader database support.","language":"javascript","status":"maintenance","version":"0.15.1","tags":["javascript","SQL","JSON","NODE"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install sql-json-generator","imports":["const SQLGenerator = require('sql-json-generator'); const sqlGenerator = new SQLGenerator();","const sqlGenerator = new SQLGenerator();","sqlGenerator.select({...})"]},{"cmd":"yarn add sql-json-generator","imports":[]},{"cmd":"pnpm add sql-json-generator","imports":[]}],"homepage":"https://github.com/manu-de-verdun/sql-json-generator#readme","github":"https://github.com/manu-de-verdun/sql-json-generator","docs":null,"changelog":null,"pypi":null,"npm":"sql-json-generator","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}