{"library":"sql-select","type":"library","category":null,"description":"A JavaScript library for performing SQL-like queries (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, JOIN) directly on arrays of objects, without requiring a database or schema. Current stable version is 3.0.1. Release cadence is irregular. Key differentiators: uses functions instead of strings/objects for queries, dependency-free (<8KB gzipped), works in browser, supports custom scalar functions and user-defined predicates. Not suitable for big data, complex queries (subqueries, set operations), or complex data types (only number and string).","language":"javascript","status":"active","version":"3.0.1","tags":["javascript","sql","select","object","arrays of objects","query","database","db","table"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install sql-select","imports":["import { SELECT } from 'sql-select'","import { FROM } from 'sql-select'","import { WHERE } from 'sql-select'"]},{"cmd":"yarn add sql-select","imports":[]},{"cmd":"pnpm add sql-select","imports":[]}],"homepage":"https://github.com/kismts/sql-select#readme","github":"https://github.com/kismts/sql-select","docs":null,"changelog":null,"pypi":null,"npm":"sql-select","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}