jSQL.js 1.0.3

jSQL facilitates the query, update and delete of items, in an array of plain objects, using JavaScript and SQL like syntax.

* SQL like syntax
* SQL feature implementation: Join, Left Join, Select [Distinct] [Top], Where, Group By, Having, Aggregate functions, Order By [Desc], Update and Delete
* User defined aggregate functions
* Lazy evaluation
* Ability to build a partial query and then extend it as a new independent query
* Full visual studio intellisense support
* Comprehensive parse-time and optional execution-time error checking

There is a newer version of this package available.
See the version list below for details.
Install-Package jSQL.js -Version 1.0.3
dotnet add package jSQL.js --version 1.0.3
<PackageReference Include="jSQL.js" Version="1.0.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add jSQL.js --version 1.0.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

Bug fix: A remove with a join sometimes removed too many items from T1.
Bug fix: The update method was interpreting a string expression as a replaceWith object.
New feature: The table specified in a from or join method can be an object that implements a getItems() method.
New feature: Multiple aliases can be specified in a remove to allow cascading deletes in a join.


This package has no dependencies.

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.0.4 722 2/22/2015
1.0.3 339 2/20/2015
1.0.1 355 2/18/2015
1.0.0 450 2/11/2015