jSQL.js
1.0.3
See the version list below for details.
dotnet add package jSQL.js --version 1.0.3
NuGet\Install-Package jSQL.js -Version 1.0.3
<PackageReference Include="jSQL.js" Version="1.0.3" />
paket add jSQL.js --version 1.0.3
#r "nuget: jSQL.js, 1.0.3"
// Install jSQL.js as a Cake Addin
#addin nuget:?package=jSQL.js&version=1.0.3
// Install jSQL.js as a Cake Tool
#tool nuget:?package=jSQL.js&version=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
Learn more about Target Frameworks and .NET Standard.
This package has no dependencies.
GitHub repositories
This package is not used by any popular GitHub repositories.
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.