@fitzy/jsql

jSQL

This is a small utility to enable using SQL style queries on JavaScript arrays of objects. Essentially it boils down to doing a reduce and a sort, but it means you don't have to set them up each time and think about it.

Install

$ npm i @fitzy/jsql

Usage

import  *  as  jsql  from  '@fitzy/jsql';

jsql.select('SELECT * FROM myData', { myData: [{a: 1, b: 'foo'}, {a: 4, b: 'bar'}, ...], relatedData: [] });

The data is passed in as an array to: a) allow putting the key in the select statement, and b) allow me to expand this to have joins later

Supported Syntax

• SELECT
• FROM
• WHERE (=, <=, >=, <, >, <>, like, in, between)
• ORDER BY

Yet to Implement

• GROUP BY
• HAVING
• Aggregate functions (avg, count, etc)
• Dates
• Aliasing (i.e. AS)