{"library":"json-sql-builder","type":"library","category":null,"description":"Build SQL queries from JSON objects with a MongoDB-like syntax. Current version 1.0.26 is in active development with support for ANSI-SQL, MySQL, and PostgreSQL dialects. The library generates parameterized SQL strings and value arrays, supporting SELECT, INSERT, UPDATE, DELETE, CREATE, JOINs, subqueries, and PostgreSQL JSON helpers. Key differentiator: enables dynamic query construction from JSON configurations, similar to Mongo query language.","language":"javascript","status":"active","version":"1.0.26","tags":["javascript","sql","mysql","mongo","json","build","translate","postgre"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install json-sql-builder","imports":["const SQLBuilder = require('json-sql-builder');","new SQLBuilder('mysql');","sqlbuilder.build($select: { $from: 'table' });"]},{"cmd":"yarn add json-sql-builder","imports":[]},{"cmd":"pnpm add json-sql-builder","imports":[]}],"homepage":"https://github.com/planetarydev/json-sql-builder#readme","github":"https://github.com/planetarydev/json-sql-builder","docs":null,"changelog":null,"pypi":null,"npm":"json-sql-builder","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}