{"library":"json-sql","type":"library","category":null,"description":"A Node.js library that translates MongoDB-style query objects into SQL queries. Version 0.5.0 is the current stable release, though development activity appears low. It is not a database driver; it only generates SQL strings and parameter values for use with any SQL driver (e.g., node-postgres). Supports SELECT, INSERT, UPDATE, DELETE, JOINs, nested conditions, and parameterized queries with automatic variable naming. Differentiators include a simple JSON-based query syntax, no DSL, and zero runtime dependencies.","language":"javascript","status":"maintenance","version":"0.5.0","tags":["javascript","json-sql","json","sql","odm","mapper","db","database"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install json-sql","imports":["import jsonSql from 'json-sql'; const sql = jsonSql();","import { builder } from 'json-sql'; const sql = builder();","const result = jsonSql().build({type: 'select', table: 'users'}); result.query; result.values;"]},{"cmd":"yarn add json-sql","imports":[]},{"cmd":"pnpm add json-sql","imports":[]}],"homepage":"https://github.com/2do2go/json-sql#readme","github":"ssh://git@github.com/2do2go/json-sql","docs":null,"changelog":null,"pypi":null,"npm":"json-sql","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}