{"id":43904,"library":"sql-from-mongo","title":"sql-from-mongo","description":"Converts MongoDB-like query objects into SQL WHERE clauses or full SELECT statements, targeting DocumentDB and similar SQL databases. Version 0.2.1 is the latest, with infrequent releases. Supports most MongoDB query operators ($or, $and, $gt, $in, etc.) plus extras like $startsWith, $isArray, and $geoWithin. Designed for single-table queries, no joins. Lightweight with zero dependencies. Key differentiator: simple, direct translation without a query builder layer. Not actively maintained.","status":"maintenance","version":"0.2.1","language":"javascript","source_language":"en","source_url":"ssh://git@github.com/lmaccherone/sql-from-mongo","tags":["javascript","Azure","DocumentDB","SQL","MongoDB"],"install":[{"cmd":"npm install sql-from-mongo","lang":"bash","label":"npm"},{"cmd":"yarn add sql-from-mongo","lang":"bash","label":"yarn"},{"cmd":"pnpm add sql-from-mongo","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[{"note":"Only named export; no default export.","wrong":"const sqlFromMongo = require('sql-from-mongo')","symbol":"sqlFromMongo","correct":"import { sqlFromMongo } from 'sql-from-mongo'"},{"note":"Module exports a single named export, not a default.","wrong":"import sqlFromMongo from 'sql-from-mongo'","symbol":"default import","correct":"import { sqlFromMongo } from 'sql-from-mongo'"},{"note":"CommonJS destructuring required for named export.","wrong":"const sqlFromMongo = require('sql-from-mongo')","symbol":"require","correct":"const { sqlFromMongo } = require('sql-from-mongo')"}],"quickstart":{"code":"const { sqlFromMongo } = require('sql-from-mongo');\n\nconst query = { user: 'Alice', age: { $gte: 18 } };\nconst sqlWhere = sqlFromMongo(query, 'users');\nconsole.log(sqlWhere);\n// users.user = 'Alice' AND users.age >= 18\n\n// Full SELECT with fields\nconst fullQuery = sqlFromMongo(query, 'users', ['name', 'email']);\nconsole.log(fullQuery);\n// SELECT users.name, users.email FROM users WHERE users.user = 'Alice' AND users.age >= 18","lang":"javascript","description":"Convert a simple MongoDB-like filter to a SQL WHERE clause and a full SELECT statement."},"warnings":[{"fix":"Flatten nested queries manually or use $in for array fields explicitly via 'fieldName' syntax with an array value.","message":"No support for nested documents or array field matching; direct scalar equality only.","severity":"gotcha","affected_versions":">=0.0.0"},{"fix":"Always use an array for $in values unless intentionally referencing another field.","message":"The $in operator can also accept a field name string (e.g., { $in: 'field'}) to reference another field — unexpected if not documented.","severity":"gotcha","affected_versions":">=0.0.0"},{"fix":"Consider migrating to a more active library like mongodb-query-to-sql or writing manual SQL.","message":"Package is in maintenance mode with no recent updates; may not support newer Node.js versions.","severity":"deprecated","affected_versions":">=0.2.0"}],"env_vars":null,"search_vec":"'0.2.1':26 'activ':73 'azur':76 'builder':70 'claus':14 'convert':5 'databas':24 'depend':61 'design':50 'differenti':63 'direct':65 'documentdb':20,77 'etc':42 'extra':44 'full':16 'geowithin':49 'gt':40 'infrequ':31 'isarray':47 'javascript':75 'join':57 'key':62 'latest':29 'layer':71 'lightweight':58 'like':8,45 'maintain':74 'mongo':4 'mongodb':7,35,79 'mongodb-lik':6 'object':10 'oper':37 'plus':43 'queri':9,36,55,69 'releas':32 'select':17 'similar':22 'simpl':64 'singl':53 'single-t':52 'sql':2,12,23,78 'sql-from-mongo':1 'startswith':46 'statement':18 'support':33 'tabl':54 'target':19 'translat':66 'version':25 'without':67 'zero':60","created_at":"2026-06-05T17:02:02.169710+00:00","updated_at":"2026-06-05T17:02:02.169710+00:00","problems":[{"fix":"Run 'npm install sql-from-mongo' in your project root.","cause":"Package not installed or not found in node_modules.","error":"Error: Cannot find module 'sql-from-mongo'"},{"fix":"Use 'import { sqlFromMongo } from 'sql-from-mongo'' or 'const { sqlFromMongo } = require('sql-from-mongo')'.","cause":"Incorrect import style — likely attempted default import when only named export exists.","error":"TypeError: sqlFromMongo is not a function"},{"fix":"Use require() or set 'type': 'module' in package.json.","cause":"Using ES module import syntax in a CommonJS file without .mjs extension or appropriate package.json config.","error":"SyntaxError: Unexpected token ."}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/lmaccherone/sql-from-mongo#readme","github":"ssh://git@github.com/lmaccherone/sql-from-mongo","docs":null,"changelog":null,"pypi":null,"npm":"sql-from-mongo","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}