{"library":"jl-sql-api","type":"library","category":null,"description":"Stream-based SQL query engine for JavaScript objects, v2.8.1 (latest). Enables SELECT, UPDATE, DELETE, INSERT on Node.js object streams with support for infinite streams, external sorting via Unix sort, GROUP BY, JOIN (INNER/LEFT), and type casting. Unlike in-memory libraries, it processes large datasets without loading entirely into memory. Key differentiators: stream-native API, MySQL-like SQL dialect without FROM clause, JOIN syntax using '@table' notation, and support for JSON streams, arrays, and custom formats.","language":"javascript","status":"active","version":"2.8.1","tags":["javascript","sql","stream"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install jl-sql-api","imports":["const JlSqlApi = require('jl-sql-api');","const { JlSqlApi } = require('jl-sql-api');","const api = new JlSqlApi(); api.query('SELECT ...');"]},{"cmd":"yarn add jl-sql-api","imports":[]},{"cmd":"pnpm add jl-sql-api","imports":[]}],"homepage":"https://github.com/avz/node-jl-sql-api#readme","github":"https://github.com/avz/node-jl-sql-api","docs":null,"changelog":null,"pypi":null,"npm":"jl-sql-api","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}