SlimSQL

SlimSQL is a lightweight in-memory SQL query engine for JavaScript, version 1.0.15. It allows running SQL queries directly on JavaScript arrays by registering them as virtual tables. It supports SELECT, JOINs, window functions (e.g., RANK), WHERE, GROUP BY, ORDER BY, and aggregation. Different from libraries like alasql, SlimSQL is minimal (43KB gzipped) with no dependencies, TypeScript types included, and focuses on basic SQL for data exploration. Release cadence is moderate; last update May 2023. Works in Node.js and browsers (ESM/CJS/UMD).