{"library":"jsonsql","type":"library","category":null,"description":"jsonSQL is a lightweight JavaScript library that allows querying JSON objects with a SQL-like syntax. It supports field selection (`*`, nested fields), conditions (`where`) with AND (`&&`), OR (`||`), grouping, and comparisons (`=`, `!=`, `like`, `!~`, `<`, `>`, `<=`, `>=`). Version 0.2.5 is the latest stable release. The library works with nested objects and arrays, supports date comparisons via timestamps, and returns matching objects as an array. It is designed for simple in-memory queries on JavaScript objects without a database, but has limited advanced features like aggregation or joins.","language":"javascript","status":"active","version":"0.2.5","tags":["javascript","query","JSON","SQL","object","DSL"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install jsonsql","imports":["import jsonSQL from 'jsonsql'","const Query = require('jsonsql')","import jsonsql from 'jsonsql'; const res: any[] = jsonsql(data, query);"]},{"cmd":"yarn add jsonsql","imports":[]},{"cmd":"pnpm add jsonsql","imports":[]}],"homepage":"https://github.com/rockdragon/jsonSQL#readme","github":"git://github.com/rockdragon/jsonSQL","docs":null,"changelog":null,"pypi":null,"npm":"jsonsql","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}