{"library":"mongo-sql","type":"library","category":null,"description":"Mongo-sql is a Node.js library that converts JSON-style query definitions into SQL strings, with a focus on PostgreSQL syntax. As of version 6.2.0 (stable, with irregular releases), it supports SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, JOINs, subqueries, and more. Unlike chain-style SQL builders, mongo-sql uses plain JavaScript objects to represent queries, making them easy to manipulate programmatically. It generates parameterized queries with `$N` placeholders to prevent SQL injection. Designed for extensibility and semantic clarity, it is ideal for developers who want a declarative, data-driven approach to SQL generation.","language":"javascript","status":"active","version":"6.2.0","tags":["javascript","postgres","postgresql","node-pg","mongo","sql"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install mongo-sql","imports":["const mongoSql = require('mongo-sql');","const { sql } = require('mongo-sql');","const { helpers } = require('mongo-sql');"]},{"cmd":"yarn add mongo-sql","imports":[]},{"cmd":"pnpm add mongo-sql","imports":[]}],"homepage":"https://github.com/goodybag/mongo-sql#readme","github":"git://github.com/goodybag/mongo-sql","docs":null,"changelog":null,"pypi":null,"npm":"mongo-sql","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}