Package detail

@balena/abstract-sql-compiler

balena-io-modules45.3k10.6.0

A translator for abstract sql into sql.

readme

Convert abstract SQL into dialect-specific SQL.

changelog

Change Log

All notable changes to this project will be documented in this file automatically by Versionist. DO NOT EDIT THIS FILE MANUALLY! This project adheres to Semantic Versioning.

10.6.0 - 2025-07-14

Export abstractSqlContainsNode helper function [Pagan Gazzard]

10.5.1 - 2025-07-08

Allow sbvr-types v11 [joshbwlng]

10.5.0 - 2025-07-07

Add optional time zone argument for DateTrunc [joshbwlng]

10.4.1 - 2025-07-04

Correctly treat EqualsAnyNode as the boolean type we know it to be [Pagan Gazzard]

10.4.0 - 2025-06-20

Export an optimizeSchema variant that is database engine agnostic [Pagan Gazzard]

10.3.5 - 2025-06-20

Switch to using a duplicate function exception to handle double function creation [Pagan Gazzard]

10.3.4 - 2025-06-20

Throw an error when trying to combine computed fields with a definition [Pagan Gazzard]

10.3.3 - 2025-06-19

Allow sbvr-types v10 as peer dependency [Otavio Jacobi]

10.3.2 - 2025-06-12

Extend IsNotDistinctFrom paren omission to more atomic node types [Pagan Gazzard]

10.3.1 - 2025-06-12

Omit parens for IsNotDistinctFrom when the value is a field node [Pagan Gazzard]

10.3.0 - 2025-06-12

Treat CaseNode as an unknown type node as expected [Pagan Gazzard]

10.2.12 - 2025-06-05

Update dependency lint-staged to v16 [balena-renovate[bot]]

10.2.11 - 2025-06-04

Add missing ; in trigger creation $$ section [Thodoris Greasidis]

10.2.10 - 2025-04-08

Update @balena/lint to 9.x [Pagan Gazzard]

10.2.9 - 2025-04-07

Avoid lodash chaining / move lodash to a dev dependency [Pagan Gazzard]
Use native version of uniq [Pagan Gazzard]
Use native version of mapValues [Pagan Gazzard]
Use native version of isEqual [Pagan Gazzard]
Use native version of flatMap [Pagan Gazzard]
Use native version of find [Pagan Gazzard]
Avoid using lodash identity method [Pagan Gazzard]
Avoid using lodash for duration node validation [Pagan Gazzard]

10.2.8 - 2025-04-07

Improve typings for the In/NotIn optimization helpers [Pagan Gazzard]

10.2.7 - 2025-04-07

Switch to a more standard isFieldTypeNode helper [Pagan Gazzard]

10.2.6 - 2025-04-07

Tests: convert test/sbvr/reference-type to typescript [Pagan Gazzard]
Tests: convert test/sbvr/pilots to typescript [Pagan Gazzard]
Tests: convert test/sbvr/test to typescript [Pagan Gazzard]
Tests: convert test/odata/expand to typescript [Pagan Gazzard]
Tests: convert test/odata/filterby to typescript [Pagan Gazzard]
Tests: convert test/odata/orderby to typescript [Pagan Gazzard]
Tests: convert test/odata/paging to typescript [Pagan Gazzard]
Tests: convert test/odata/resource_parsing to typescript [Pagan Gazzard]
Tests: convert test/odata/select to typescript [Pagan Gazzard]
Tests: convert test/odata/stress to typescript [Pagan Gazzard]

10.2.5 - 2025-04-06

Tests: convert test/odata/test to typescript [Pagan Gazzard]

10.2.4 - 2025-04-04

Update dev dependencies [Pagan Gazzard]

10.2.3 - 2025-03-19

Tests: convert test/abstract-sql/case-when-else.js to typescript [Pagan Gazzard]
Tests: convert test/abstract-sql/test.js to typescript [Pagan Gazzard]
Tests: simplify handling of variadic test helper functions [Pagan Gazzard]

10.2.2 - 2025-02-14

Clarify the ['Bind', string, string] form of BindNode is legacy [Pagan Gazzard]

10.2.1 - 2025-01-29

Fix @balena/sbvr-types peer dependency version specifier [Pagan Gazzard]

10.2.0 - 2025-01-22

Add EqualAny node [Otavio Jacobi]

10.1.2 - 2025-01-06

<summary> Update dependency @balena/odata-to-abstract-sql to v7 [Self-hosted Renovate Bot] </summary>

odata-to-abstract-sql-7.0.1 - 2024-12-04

Update dependency mocha to v11 [Self-hosted Renovate Bot]

odata-to-abstract-sql-7.0.0 - 2024-10-08

<summary> Update dependencies [Thodoris Greasidis] </summary>

abstract-sql-compiler-10.0.1 - 2024-10-07

Wrap composite comparison operations with parenthesis when necessary [Thodoris Greasidis]

abstract-sql-compiler-10.0.0 - 2024-10-07

tsconfig: Switch the module compiler option to Node16 [Thodoris Greasidis]

Update tsconfig target to es2023 [Thodoris Greasidis]

Update minimum supported nodejs version to 20.14.0 [Thodoris Greasidis]

Make @balena/sbvr-types a peer dependency [Thodoris Greasidis]

Lint fixes [Thodoris Greasidis]

<summary> Update dependencies & tests to match [Thodoris Greasidis] </summary>

lf-to-abstract-sql-5.0.2 - 2024-03-05

<summary> Update `@balena/sbvr-types` devDependency [Harald Fischer] </summary>

sbvr-types-7.0.1 - 2024-03-04

Update dependency @balena/abstract-sql-compiler to v9 [Self-hosted Renovate Bot]

sbvr-types-7.0.0 - 2024-03-04

Return ISODateString instead of date [fisehara]

sbvr-types-6.1.1 - 2024-01-02

Update dependency @types/chai-datetime to ^0.0.39 [Self-hosted Renovate Bot]

sbvr-types-6.1.0 - 2023-10-03

Add checksum to WebResource [Otávio Jacobi]

sbvr-types-6.0.0 - 2023-08-09

Change contents to snake_case [Otávio Jacobi]

sbvr-types-5.2.0 - 2023-08-08

Expose WebResource as WebResourceType [Otávio Jacobi]

sbvr-types-5.1.0 - 2023-08-03

Adds WebResource type [Otávio Jacobi]

lf-to-abstract-sql-5.0.1 - 2023-05-16

<summary> Update @balena/sbvr-types to 5.0.0 [Pagan Gazzard] </summary>

sbvr-types-5.0.0 - 2023-05-16

Switch from export = to export default [Pagan Gazzard]

sbvr-types-4.0.2 - 2023-05-03

Improve typings [Pagan Gazzard]

sbvr-types-4.0.1 - 2023-05-02

boolean: Avoid unnecessary array creation to reduce GCs [Thodoris Greasidis]

sbvr-types-4.0.0 - 2023-04-26

Add test cases for Objects in JSON validate [fisehara]

Drop require-npm4-to-publish devDependency [fisehara]

Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]

Switch JSON to use JSON db type instead of TEXT [Pagan Gazzard]

Switch Boolean to use BOOLEAN db type instead of INTEGER [Pagan Gazzard]

Assert that JSON input typeof is object [Josh Bowling]

sbvr-types-3.5.0 - 2023-03-21

Add Big Serial type [Josh Bowling]

sbvr-types-3.4.19 - 2022-12-08

Flowzone: Allow external contributions [Josh Bowling]

odata-parser-3.1.0 - 2024-10-03

Use bind vars for $top and $skip options [Pagan Gazzard]

odata-parser-3.0.8 - 2024-06-04

Fix type checking of the declaration file [Pagan Gazzard]

odata-parser-3.0.7 - 2024-04-13

Update dependency husky to v9 [Self-hosted Renovate Bot]

odata-parser-3.0.6 - 2024-04-12

Update dependency peggy to v4 [Self-hosted Renovate Bot]

odata-parser-3.0.5 - 2024-04-12

Update dependency lint-staged to v15 [Self-hosted Renovate Bot]

odata-parser-3.0.4 - 2024-04-12

Update dependency @balena/lint to v8 [Self-hosted Renovate Bot]

odata-parser-3.0.3 - 2024-01-04

Optimize by moving constant values into global init [fisehara]

odata-parser-3.0.2 - 2024-01-04

Update dependencies [fisehara]

odata-parser-3.0.1 - 2023-09-25

Allow running CI on external PRs [Pagan Gazzard]

odata-to-abstract-sql-6.4.0 - 2024-10-04

<summary> Support number references as boolean types [Pagan Gazzard] </summary>

odata-parser-3.1.0 - 2024-10-03

Use bind vars for $top and $skip options [Pagan Gazzard]

odata-to-abstract-sql-6.3.0 - 2024-08-26

Support PUT/PATCH/DELETE requests on resources with a translated ID field [Thodoris Greasidis]

odata-to-abstract-sql-6.2.8 - 2024-08-26

<summary> Update dependencies [Pagan Gazzard] </summary>

abstract-sql-compiler-9.2.0 - 2024-06-12

Adds EndsWithNode and ContainsNode typings [Pagan Gazzard]

lf-to-abstract-sql-5.0.2 - 2024-03-05

<summary> Update `@balena/sbvr-types` devDependency [Harald Fischer] </summary>

# sbvr-types-7.0.1 - 2024-03-04

Update dependency @balena/abstract-sql-compiler to v9 [Self-hosted Renovate Bot]

# sbvr-types-7.0.0 - 2024-03-04

Return ISODateString instead of date [fisehara]

# sbvr-types-6.1.1 - 2024-01-02

Update dependency @types/chai-datetime to ^0.0.39 [Self-hosted Renovate Bot]

# sbvr-types-6.1.0 - 2023-10-03

Add checksum to WebResource [Otávio Jacobi]

# sbvr-types-6.0.0 - 2023-08-09

Change contents to snake_case [Otávio Jacobi]

# sbvr-types-5.2.0 - 2023-08-08

Expose WebResource as WebResourceType [Otávio Jacobi]

# sbvr-types-5.1.0 - 2023-08-03

Adds WebResource type [Otávio Jacobi]

odata-parser-3.0.8 - 2024-06-04

Fix type checking of the declaration file [Pagan Gazzard]

odata-parser-3.0.7 - 2024-04-13

Update dependency husky to v9 [Self-hosted Renovate Bot]

odata-parser-3.0.6 - 2024-04-12

Update dependency peggy to v4 [Self-hosted Renovate Bot]

odata-parser-3.0.5 - 2024-04-12

Update dependency lint-staged to v15 [Self-hosted Renovate Bot]

odata-parser-3.0.4 - 2024-04-12

Update dependency @balena/lint to v8 [Self-hosted Renovate Bot]

sbvr-parser-1.4.6 - Invalid date

Update dependency @balena/sbvr-types to v8 [Self-hosted Renovate Bot]

sbvr-parser-1.4.5 - 2024-06-18

Switch to an inflection library from npm which does not monkey patch [Pagan Gazzard]

sbvr-parser-1.4.4 - 2024-03-05

Updated @balena/sbvr-types [Harald Fischer]

sbvr-types-7.1.3 - 2024-06-12

Add typings for all abstract sql fragments, fixing where necessary [Pagan Gazzard]

sbvr-types-7.1.2 - 2024-06-12

Explicitly type the compare function for hashed [Pagan Gazzard]

sbvr-types-7.1.1 - 2024-06-04

Accept Date for the write types of Date Time/Date/Time [Pagan Gazzard]

sbvr-types-7.1.0 - 2024-04-25

Export typescript read/write types for each sbvr type [Pagan Gazzard]

sbvr-types-7.0.10 - 2024-04-09

Update Big Serial concept type to Big Integer [Josh Bowling]

sbvr-types-7.0.9 - 2024-04-09

Add Big Serial to Type.sbvr [Josh Bowling]

sbvr-types-7.0.8 - 2024-04-09

Update prepare script for husky v9 [Josh Bowling]

Update dependency husky to v9 [Self-hosted Renovate Bot]

sbvr-types-7.0.7 - 2024-04-09

Update dependency @balena/lint to v8 [Self-hosted Renovate Bot]

sbvr-types-7.0.6 - 2024-03-21

Improve JSON typings [Pagan Gazzard]

sbvr-types-7.0.5 - 2024-03-13

Remove unnecessary catch bindings [Pagan Gazzard]

sbvr-types-7.0.4 - 2024-03-13

Improve validate typings [Pagan Gazzard]

sbvr-types-7.0.3 - 2024-03-12

Improve fetchProcessing typings [Pagan Gazzard]

sbvr-types-7.0.2 - 2024-03-12

Tests: convert to typescript [Pagan Gazzard]

odata-to-abstract-sql-6.2.7 - 2024-04-23

<summary> Properly error when using fields of a partial index as an alternate key [Thodoris Greasidis] </summary>

abstract-sql-compiler-9.1.4 - 2024-04-09

Cast Big Serial to integer [Josh Bowling]

abstract-sql-compiler-9.1.3 - 2024-04-09

Update prepare script for husky v9 [Josh Bowling]

Update dependency husky to v9 [Self-hosted Renovate Bot]

abstract-sql-compiler-9.1.2 - 2024-04-09

Update dependency lint-staged to v15 [Self-hosted Renovate Bot]

abstract-sql-compiler-9.1.1 - 2024-03-26

Update dependency @balena/lint to v8 [Thodoris Greasidis]

abstract-sql-compiler-9.1.0 - 2024-03-26

Export the generateRuleHashAcronym helper [Thodoris Greasidis]

Add support for unique indexes with NOT DISTINCT NULLS [Thodoris Greasidis]

Add support for partial unique indexes [Thodoris Greasidis]

abstract-sql-compiler-9.0.7 - 2024-03-22

<summary> Update dependency @balena/odata-parser to v3 [Self-hosted Renovate Bot] </summary>

# odata-parser-3.0.3 - 2024-01-04

Optimize by moving constant values into global init [fisehara]

# odata-parser-3.0.2 - 2024-01-04

Update dependencies [fisehara]

# odata-parser-3.0.1 - 2023-09-25

Allow running CI on external PRs [Pagan Gazzard]

# odata-parser-3.0.0 - 2023-04-26

Use optional chaining operator [Pagan Gazzard]

Set minimum supported nodejs version to 16.13.0 [Pagan Gazzard]

abstract-sql-compiler-9.0.6 - 2024-03-21

Update TypeScript to 5.4.3 [Thodoris Greasidis]

abstract-sql-compiler-9.0.5 - 2024-03-05

Update @balena/sbvr-types [Harald Fischer]

odata-to-abstract-sql-6.2.6 - 2024-04-13

Update dependency husky to v9 [Self-hosted Renovate Bot]

odata-to-abstract-sql-6.2.5 - 2024-04-10

Update dependency @balena/lint to v8 [Self-hosted Renovate Bot]

odata-to-abstract-sql-6.2.4 - 2024-03-05

Update @balena/sbvr-types devDependencies [fisehara]

Fix linter issue [fisehara]

odata-to-abstract-sql-6.2.3 - 2024-01-15

Require at least one field to be updated for PATCH requests [Pagan Gazzard]

odata-to-abstract-sql-6.2.2 - 2024-01-15

Simplify support for MERGE as an alias for PATCH [Pagan Gazzard]

odata-to-abstract-sql-6.2.1 - 2024-01-15

<summary> Update dependencies [Pagan Gazzard] </summary>

abstract-sql-compiler-9.0.4 - 2024-01-02

Update dependency @types/node to v20 [Self-hosted Renovate Bot]

odata-parser-3.0.3 - 2024-01-04

Optimize by moving constant values into global init [fisehara]

odata-parser-3.0.2 - 2024-01-04

Update dependencies [fisehara]

sbvr-types-6.1.1 - 2024-01-02

Update dependency @types/chai-datetime to ^0.0.39 [Self-hosted Renovate Bot]

odata-to-abstract-sql-6.2.0 - 2023-11-24

Optimize Duplications of ComputedField queries [fisehara]

odata-to-abstract-sql-6.1.3 - 2023-11-10

Update dependency @types/chai-things to v0.0.38 [Self-hosted Renovate Bot]

odata-to-abstract-sql-6.1.2 - 2023-10-20

Update dependency @types/chai-things to v0.0.37 [Self-hosted Renovate Bot]

odata-to-abstract-sql-6.1.1 - 2023-10-19

<summary> Update dependencies eslint, sbvrTypes, abstract-sql-compiler [Harald Fischer] </summary>

abstract-sql-compiler-9.0.3 - 2023-08-09

<summary> Update @balena/sbvr-types to 6.0.0 [Otávio Jacobi] </summary>

# sbvr-types-6.0.0 - 2023-08-09

Change contents to snake_case [Otávio Jacobi]

# sbvr-types-5.2.0 - 2023-08-08

Expose WebResource as WebResourceType [Otávio Jacobi]

# sbvr-types-5.1.0 - 2023-08-03

Adds WebResource type [Otávio Jacobi]

abstract-sql-compiler-9.0.2 - 2023-05-16

<summary> Update @balena/sbvr-types to 5.0.0 [Pagan Gazzard] </summary>

# sbvr-types-5.0.0 - 2023-05-16

Switch from export = to export default [Pagan Gazzard]

# sbvr-types-4.0.2 - 2023-05-03

Improve typings [Pagan Gazzard]

# sbvr-types-4.0.1 - 2023-05-02

boolean: Avoid unnecessary array creation to reduce GCs [Thodoris Greasidis]

abstract-sql-compiler-9.0.1 - 2023-05-15

Fix TS errors for the latest sbvrTypes [Thodoris Greasidis]

abstract-sql-compiler-9.0.0 - 2023-05-02

Drop require-npm4-to-publish as engines used [fisehara]

<summary> Update @balena/odata-to-abstract-sql to 6.x [Pagan Gazzard] </summary>

# odata-to-abstract-sql-6.0.1 - 2023-04-27

<summary> Update dependencies [Pagan Gazzard] </summary>

## odata-parser-3.0.0 - 2023-04-26

Use optional chaining operator [Pagan Gazzard]

Set minimum supported nodejs version to 16.13.0 [Pagan Gazzard]

## odata-parser-2.5.0 - 2023-04-26

Update to peggy 3 and make us of the repetition operator [Pagan Gazzard]

## sbvr-types-4.0.0 - 2023-04-26

Add test cases for Objects in JSON validate [fisehara]

Drop require-npm4-to-publish devDependency [fisehara]

Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]

Switch JSON to use JSON db type instead of TEXT [Pagan Gazzard]

Switch Boolean to use BOOLEAN db type instead of INTEGER [Pagan Gazzard]

Assert that JSON input typeof is object [Josh Bowling]

# odata-to-abstract-sql-6.0.0 - 2023-04-26

Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]

Switch AggregateJSON to use the newer ReferencedField format [Pagan Gazzard]

# odata-to-abstract-sql-5.9.6 - 2023-04-25

Collapse AliasedFunction into FunctionMatch [Pagan Gazzard]

# odata-to-abstract-sql-5.9.5 - 2023-04-25

<summary> Improve typings [Pagan Gazzard] </summary>

## abstract-sql-compiler-8.4.1 - 2023-04-25

Add much finer grained typings for abstract-sql-optimizer [Pagan Gazzard]

# odata-to-abstract-sql-5.9.4 - 2023-04-24

<summary> Update dependencies [Pagan Gazzard] </summary>

## abstract-sql-compiler-8.4.0 - 2023-04-24

Add support for using field type nodes with an AggregateJSON node [Pagan Gazzard]

## abstract-sql-compiler-8.3.13 - 2023-04-24

Deprecate AliasableFromTypeNodes type as it's redundant [Pagan Gazzard]

## abstract-sql-compiler-8.3.12 - 2023-04-17

Revert tightening of OrderBy to only field nodes [Pagan Gazzard]

## abstract-sql-compiler-8.3.11 - 2023-04-13

Do not allow ON clauses for CROSS JOIN as it is invalid [Pagan Gazzard]

Stop accepting ExtractJSONPathAsText/ToJSON as unknown node types [Pagan Gazzard]

## abstract-sql-compiler-8.3.10 - 2023-04-13

Fix DateNode/AnyNode typings [Pagan Gazzard]

## abstract-sql-compiler-8.3.9 - 2023-04-13

<summary> Update dependencies [Pagan Gazzard] </summary>

### sbvr-types-3.5.0 - 2023-03-21

Add Big Serial type [Josh Bowling]

### sbvr-types-3.4.19 - 2022-12-08

Flowzone: Allow external contributions [Josh Bowling]

## abstract-sql-compiler-8.3.8 - 2023-04-12

Improve typings [Pagan Gazzard]

## abstract-sql-compiler-8.3.7 - 2023-04-12

Remove typing for non-existent JSON node [Pagan Gazzard]

## abstract-sql-compiler-8.3.6 - 2023-04-12

Tighten the isXValue function typings [Pagan Gazzard]

## abstract-sql-compiler-8.3.5 - 2023-04-12

Correctly treat Value nodes as rewritten to Text by the optimizer [Pagan Gazzard]

Add EmbeddedTextNode typing [Pagan Gazzard]

## abstract-sql-compiler-8.3.4 - 2023-04-12

Enforce the first argument of ExtractJSONPathAsText is a JSON type node [Pagan Gazzard]

## abstract-sql-compiler-8.3.3 - 2023-04-12

Improve node typings [Pagan Gazzard]

## abstract-sql-compiler-8.3.2 - 2023-04-12

Add more node typings [Pagan Gazzard]

## abstract-sql-compiler-8.3.1 - 2023-04-12

Add more node typings [Pagan Gazzard]

## abstract-sql-compiler-8.3.0 - 2023-04-11

Support boolean nodes in a ValuesNode [Pagan Gazzard]

## abstract-sql-compiler-8.2.0 - 2023-04-11

Add Between node type [Pagan Gazzard]

## abstract-sql-compiler-8.1.0 - 2023-04-11

Add BitwiseAnd/BitwiseShiftRight node types [Pagan Gazzard]

## abstract-sql-compiler-8.0.2 - 2023-04-06

Add NotInNode type [Pagan Gazzard]

Add IsDistinctFromNode/IsNotDistinctFromNode types [Pagan Gazzard]

Add CharacterLengthNode type [Pagan Gazzard]

## abstract-sql-compiler-8.0.1 - 2023-04-06

Adds Cast node type to tree parsing [Otávio Jacobi]

## odata-parser-2.4.6 - 2023-02-24

Improve typings [Pagan Gazzard]

## odata-parser-2.4.5 - 2023-02-23

Use const/let as appropriate [Pagan Gazzard]

## odata-parser-2.4.4 - 2023-02-23

Use shorthand object notation [Pagan Gazzard]

## odata-parser-2.4.3 - 2023-02-23

Update dependencies [Pagan Gazzard]

Remove support for the legacy AggregateJSON format of [tableName, fieldName] [Pagan Gazzard]

Remove support for the legacy boolean format of true|false [Pagan Gazzard]

Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]

Remove support for the legacy alias format of [node, alias] [Pagan Gazzard]

Remove support for the legacy table format of tableName [Pagan Gazzard]

Remove support for the legacy null formats of null and 'Null' [Pagan Gazzard]

Reflect the usage of BOOLEAN db type [Pagan Gazzard]

<summary> Update @balena/sbvr-types to 4.x [Pagan Gazzard] </summary>

# sbvr-types-4.0.0 - 2023-04-26

Add test cases for Objects in JSON validate [fisehara]

Drop require-npm4-to-publish devDependency [fisehara]

Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]

Switch JSON to use JSON db type instead of TEXT [Pagan Gazzard]

Switch Boolean to use BOOLEAN db type instead of INTEGER [Pagan Gazzard]

Assert that JSON input typeof is object [Josh Bowling]

abstract-sql-compiler-8.5.0 - 2023-04-27

Use native StartsWith node type for postgres [Pagan Gazzard]

Convert EscapeForLike into a standalone node type [Pagan Gazzard]

lf-to-abstract-sql-5.0.1 - 2023-05-16

<summary> Update @balena/sbvr-types to 5.0.0 [Pagan Gazzard] </summary>

# sbvr-types-5.0.0 - 2023-05-16

Switch from export = to export default [Pagan Gazzard]

# sbvr-types-4.0.2 - 2023-05-03

Improve typings [Pagan Gazzard]

# sbvr-types-4.0.1 - 2023-05-02

boolean: Avoid unnecessary array creation to reduce GCs [Thodoris Greasidis]

# sbvr-types-4.0.0 - 2023-04-26

Add test cases for Objects in JSON validate [fisehara]

Drop require-npm4-to-publish devDependency [fisehara]

Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]

Switch JSON to use JSON db type instead of TEXT [Pagan Gazzard]

Switch Boolean to use BOOLEAN db type instead of INTEGER [Pagan Gazzard]

Assert that JSON input typeof is object [Josh Bowling]

# sbvr-types-3.5.0 - 2023-03-21

Add Big Serial type [Josh Bowling]

# sbvr-types-3.4.19 - 2022-12-08

Flowzone: Allow external contributions [Josh Bowling]

odata-parser-3.0.1 - 2023-09-25

Allow running CI on external PRs [Pagan Gazzard]

sbvr-types-6.1.0 - 2023-10-03

Add checksum to WebResource [Otávio Jacobi]

sbvr-types-6.0.0 - 2023-08-09

Change contents to snake_case [Otávio Jacobi]

sbvr-types-5.2.0 - 2023-08-08

Expose WebResource as WebResourceType [Otávio Jacobi]

sbvr-types-5.1.0 - 2023-08-03

Adds WebResource type [Otávio Jacobi]

sbvr-types-5.0.0 - 2023-05-16

Switch from export = to export default [Pagan Gazzard]

sbvr-types-4.0.2 - 2023-05-03

Improve typings [Pagan Gazzard]

sbvr-types-4.0.1 - 2023-05-02

boolean: Avoid unnecessary array creation to reduce GCs [Thodoris Greasidis]

odata-to-abstract-sql-6.1.0 - 2023-08-16

Support bind references as boolean types [Pagan Gazzard]

sbvr-parser-1.4.6 - Invalid date

Update dependency @balena/sbvr-types to v8 [Self-hosted Renovate Bot]

sbvr-parser-1.4.5 - 2024-06-18

Switch to an inflection library from npm which does not monkey patch [Pagan Gazzard]

sbvr-parser-1.4.4 - 2024-03-05

Updated @balena/sbvr-types [Harald Fischer]

sbvr-types-9.0.2 - 2024-09-17

Change the exported Types to an interface so that they can be augmented [Thodoris Greasidis]

sbvr-types-9.0.1 - 2024-08-05

Update @balena/lint to v8.2.7 [Josh Bowling]

sbvr-types-9.0.0 - 2024-08-02

Update BigInteger and BigSerial TsTypes [Josh Bowling]

sbvr-types-8.0.0 - 2024-06-12

Improve BigInteger and BigSerial support [Josh Bowling]

sbvr-types-7.1.3 - 2024-06-12

Add typings for all abstract sql fragments, fixing where necessary [Pagan Gazzard]

sbvr-types-7.1.2 - 2024-06-12

Explicitly type the compare function for hashed [Pagan Gazzard]

sbvr-types-7.1.1 - 2024-06-04

Accept Date for the write types of Date Time/Date/Time [Pagan Gazzard]

sbvr-types-7.1.0 - 2024-04-25

Export typescript read/write types for each sbvr type [Pagan Gazzard]

sbvr-types-7.0.10 - 2024-04-09

Update Big Serial concept type to Big Integer [Josh Bowling]

sbvr-types-7.0.9 - 2024-04-09

Add Big Serial to Type.sbvr [Josh Bowling]

sbvr-types-7.0.8 - 2024-04-09

Update prepare script for husky v9 [Josh Bowling]

Update dependency husky to v9 [Self-hosted Renovate Bot]

sbvr-types-7.0.7 - 2024-04-09

Update dependency @balena/lint to v8 [Self-hosted Renovate Bot]

sbvr-types-7.0.6 - 2024-03-21

Improve JSON typings [Pagan Gazzard]

sbvr-types-7.0.5 - 2024-03-13

Remove unnecessary catch bindings [Pagan Gazzard]

sbvr-types-7.0.4 - 2024-03-13

Improve validate typings [Pagan Gazzard]

sbvr-types-7.0.3 - 2024-03-12

Improve fetchProcessing typings [Pagan Gazzard]

sbvr-types-7.0.2 - 2024-03-12

Tests: convert to typescript [Pagan Gazzard]

sbvr-types-9.0.2 - 2024-09-17

Change the exported Types to an interface so that they can be augmented [Thodoris Greasidis]

sbvr-types-9.0.1 - 2024-08-05

Update @balena/lint to v8.2.7 [Josh Bowling]

sbvr-types-9.0.0 - 2024-08-02

Update BigInteger and BigSerial TsTypes [Josh Bowling]

sbvr-types-8.0.0 - 2024-06-12

Improve BigInteger and BigSerial support [Josh Bowling]

tsconfig: Switch the module compiler option to Node16 [Thodoris Greasidis]

Update minimum supported nodejs version to 20.14.0 [Thodoris Greasidis]

10.1.1 - 2025-01-06

Update dependency mocha to v11 [Self-hosted Renovate Bot]

10.1.0 - 2024-10-24

Add Lower unary node for countTableSelects optimization [Otavio Jacobi]

10.0.1 - 2024-10-07

Wrap composite comparison operations with parenthesis when necessary [Thodoris Greasidis]

10.0.0 - 2024-10-07

tsconfig: Switch the module compiler option to Node16 [Thodoris Greasidis]
Update tsconfig target to es2023 [Thodoris Greasidis]
Update minimum supported nodejs version to 20.14.0 [Thodoris Greasidis]
Make @balena/sbvr-types a peer dependency [Thodoris Greasidis]
Lint fixes [Thodoris Greasidis]

<summary> Update dependencies & tests to match [Thodoris Greasidis] </summary>

lf-to-abstract-sql-5.0.2 - 2024-03-05

<summary> Update `@balena/sbvr-types` devDependency [Harald Fischer] </summary>

sbvr-types-7.0.1 - 2024-03-04

Update dependency @balena/abstract-sql-compiler to v9 [Self-hosted Renovate Bot]

sbvr-types-7.0.0 - 2024-03-04

Return ISODateString instead of date [fisehara]

sbvr-types-6.1.1 - 2024-01-02

Update dependency @types/chai-datetime to ^0.0.39 [Self-hosted Renovate Bot]

sbvr-types-6.1.0 - 2023-10-03

Add checksum to WebResource [Otávio Jacobi]

sbvr-types-6.0.0 - 2023-08-09

Change contents to snake_case [Otávio Jacobi]

sbvr-types-5.2.0 - 2023-08-08

Expose WebResource as WebResourceType [Otávio Jacobi]

sbvr-types-5.1.0 - 2023-08-03

Adds WebResource type [Otávio Jacobi]

lf-to-abstract-sql-5.0.1 - 2023-05-16

<summary> Update @balena/sbvr-types to 5.0.0 [Pagan Gazzard] </summary>

sbvr-types-5.0.0 - 2023-05-16

Switch from export = to export default [Pagan Gazzard]

sbvr-types-4.0.2 - 2023-05-03

Improve typings [Pagan Gazzard]

sbvr-types-4.0.1 - 2023-05-02

boolean: Avoid unnecessary array creation to reduce GCs [Thodoris Greasidis]

sbvr-types-4.0.0 - 2023-04-26

Add test cases for Objects in JSON validate [fisehara]

Drop require-npm4-to-publish devDependency [fisehara]

Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]

Switch JSON to use JSON db type instead of TEXT [Pagan Gazzard]

Switch Boolean to use BOOLEAN db type instead of INTEGER [Pagan Gazzard]

Assert that JSON input typeof is object [Josh Bowling]

sbvr-types-3.5.0 - 2023-03-21

Add Big Serial type [Josh Bowling]

sbvr-types-3.4.19 - 2022-12-08

Flowzone: Allow external contributions [Josh Bowling]

odata-parser-3.1.0 - 2024-10-03

Use bind vars for $top and $skip options [Pagan Gazzard]

odata-parser-3.0.8 - 2024-06-04

Fix type checking of the declaration file [Pagan Gazzard]

odata-parser-3.0.7 - 2024-04-13

Update dependency husky to v9 [Self-hosted Renovate Bot]

odata-parser-3.0.6 - 2024-04-12

Update dependency peggy to v4 [Self-hosted Renovate Bot]

odata-parser-3.0.5 - 2024-04-12

Update dependency lint-staged to v15 [Self-hosted Renovate Bot]

odata-parser-3.0.4 - 2024-04-12

Update dependency @balena/lint to v8 [Self-hosted Renovate Bot]

odata-parser-3.0.3 - 2024-01-04

Optimize by moving constant values into global init [fisehara]

odata-parser-3.0.2 - 2024-01-04

Update dependencies [fisehara]

odata-parser-3.0.1 - 2023-09-25

Allow running CI on external PRs [Pagan Gazzard]

odata-to-abstract-sql-6.4.0 - 2024-10-04

<summary> Support number references as boolean types [Pagan Gazzard] </summary>

odata-parser-3.1.0 - 2024-10-03

Use bind vars for $top and $skip options [Pagan Gazzard]

odata-to-abstract-sql-6.3.0 - 2024-08-26

Support PUT/PATCH/DELETE requests on resources with a translated ID field [Thodoris Greasidis]

odata-to-abstract-sql-6.2.8 - 2024-08-26

<summary> Update dependencies [Pagan Gazzard] </summary>

abstract-sql-compiler-9.2.0 - 2024-06-12

Adds EndsWithNode and ContainsNode typings [Pagan Gazzard]

lf-to-abstract-sql-5.0.2 - 2024-03-05

<summary> Update `@balena/sbvr-types` devDependency [Harald Fischer] </summary>

sbvr-types-7.0.1 - 2024-03-04

Update dependency @balena/abstract-sql-compiler to v9 [Self-hosted Renovate Bot]

sbvr-types-7.0.0 - 2024-03-04

Return ISODateString instead of date [fisehara]

sbvr-types-6.1.1 - 2024-01-02

Update dependency @types/chai-datetime to ^0.0.39 [Self-hosted Renovate Bot]

sbvr-types-6.1.0 - 2023-10-03

Add checksum to WebResource [Otávio Jacobi]

sbvr-types-6.0.0 - 2023-08-09

Change contents to snake_case [Otávio Jacobi]

sbvr-types-5.2.0 - 2023-08-08

Expose WebResource as WebResourceType [Otávio Jacobi]

sbvr-types-5.1.0 - 2023-08-03

Adds WebResource type [Otávio Jacobi]

odata-parser-3.0.8 - 2024-06-04

Fix type checking of the declaration file [Pagan Gazzard]

odata-parser-3.0.7 - 2024-04-13

Update dependency husky to v9 [Self-hosted Renovate Bot]

odata-parser-3.0.6 - 2024-04-12

Update dependency peggy to v4 [Self-hosted Renovate Bot]

odata-parser-3.0.5 - 2024-04-12

Update dependency lint-staged to v15 [Self-hosted Renovate Bot]

odata-parser-3.0.4 - 2024-04-12

Update dependency @balena/lint to v8 [Self-hosted Renovate Bot]

sbvr-parser-1.4.6 - Invalid date

Update dependency @balena/sbvr-types to v8 [Self-hosted Renovate Bot]

sbvr-parser-1.4.5 - 2024-06-18

Switch to an inflection library from npm which does not monkey patch [Pagan Gazzard]

sbvr-parser-1.4.4 - 2024-03-05

Updated @balena/sbvr-types [Harald Fischer]

sbvr-types-7.1.3 - 2024-06-12

Add typings for all abstract sql fragments, fixing where necessary [Pagan Gazzard]

sbvr-types-7.1.2 - 2024-06-12

Explicitly type the compare function for hashed [Pagan Gazzard]

sbvr-types-7.1.1 - 2024-06-04

Accept Date for the write types of Date Time/Date/Time [Pagan Gazzard]

sbvr-types-7.1.0 - 2024-04-25

Export typescript read/write types for each sbvr type [Pagan Gazzard]

sbvr-types-7.0.10 - 2024-04-09

Update Big Serial concept type to Big Integer [Josh Bowling]

sbvr-types-7.0.9 - 2024-04-09

Add Big Serial to Type.sbvr [Josh Bowling]

sbvr-types-7.0.8 - 2024-04-09

Update prepare script for husky v9 [Josh Bowling]

Update dependency husky to v9 [Self-hosted Renovate Bot]

sbvr-types-7.0.7 - 2024-04-09

Update dependency @balena/lint to v8 [Self-hosted Renovate Bot]

sbvr-types-7.0.6 - 2024-03-21

Improve JSON typings [Pagan Gazzard]

sbvr-types-7.0.5 - 2024-03-13

Remove unnecessary catch bindings [Pagan Gazzard]

sbvr-types-7.0.4 - 2024-03-13

Improve validate typings [Pagan Gazzard]

sbvr-types-7.0.3 - 2024-03-12

Improve fetchProcessing typings [Pagan Gazzard]

sbvr-types-7.0.2 - 2024-03-12

Tests: convert to typescript [Pagan Gazzard]

odata-to-abstract-sql-6.2.7 - 2024-04-23

<summary> Properly error when using fields of a partial index as an alternate key [Thodoris Greasidis] </summary>

abstract-sql-compiler-9.1.4 - 2024-04-09

Cast Big Serial to integer [Josh Bowling]

abstract-sql-compiler-9.1.3 - 2024-04-09

Update prepare script for husky v9 [Josh Bowling]

Update dependency husky to v9 [Self-hosted Renovate Bot]

abstract-sql-compiler-9.1.2 - 2024-04-09

Update dependency lint-staged to v15 [Self-hosted Renovate Bot]

abstract-sql-compiler-9.1.1 - 2024-03-26

Update dependency @balena/lint to v8 [Thodoris Greasidis]

abstract-sql-compiler-9.1.0 - 2024-03-26

Export the generateRuleHashAcronym helper [Thodoris Greasidis]

Add support for unique indexes with NOT DISTINCT NULLS [Thodoris Greasidis]

Add support for partial unique indexes [Thodoris Greasidis]

abstract-sql-compiler-9.0.7 - 2024-03-22

<summary> Update dependency @balena/odata-parser to v3 [Self-hosted Renovate Bot] </summary>

odata-parser-3.0.3 - 2024-01-04

Optimize by moving constant values into global init [fisehara]

odata-parser-3.0.2 - 2024-01-04

Update dependencies [fisehara]

odata-parser-3.0.1 - 2023-09-25

Allow running CI on external PRs [Pagan Gazzard]

odata-parser-3.0.0 - 2023-04-26

Use optional chaining operator [Pagan Gazzard]

Set minimum supported nodejs version to 16.13.0 [Pagan Gazzard]

abstract-sql-compiler-9.0.6 - 2024-03-21

Update TypeScript to 5.4.3 [Thodoris Greasidis]

abstract-sql-compiler-9.0.5 - 2024-03-05

Update @balena/sbvr-types [Harald Fischer]

odata-to-abstract-sql-6.2.6 - 2024-04-13

Update dependency husky to v9 [Self-hosted Renovate Bot]

odata-to-abstract-sql-6.2.5 - 2024-04-10

Update dependency @balena/lint to v8 [Self-hosted Renovate Bot]

odata-to-abstract-sql-6.2.4 - 2024-03-05

Update @balena/sbvr-types devDependencies [fisehara]

Fix linter issue [fisehara]

odata-to-abstract-sql-6.2.3 - 2024-01-15

Require at least one field to be updated for PATCH requests [Pagan Gazzard]

odata-to-abstract-sql-6.2.2 - 2024-01-15

Simplify support for MERGE as an alias for PATCH [Pagan Gazzard]

odata-to-abstract-sql-6.2.1 - 2024-01-15

<summary> Update dependencies [Pagan Gazzard] </summary>

abstract-sql-compiler-9.0.4 - 2024-01-02

Update dependency @types/node to v20 [Self-hosted Renovate Bot]

odata-parser-3.0.3 - 2024-01-04

Optimize by moving constant values into global init [fisehara]

odata-parser-3.0.2 - 2024-01-04

Update dependencies [fisehara]

sbvr-types-6.1.1 - 2024-01-02

Update dependency @types/chai-datetime to ^0.0.39 [Self-hosted Renovate Bot]

odata-to-abstract-sql-6.2.0 - 2023-11-24

Optimize Duplications of ComputedField queries [fisehara]

odata-to-abstract-sql-6.1.3 - 2023-11-10

Update dependency @types/chai-things to v0.0.38 [Self-hosted Renovate Bot]

odata-to-abstract-sql-6.1.2 - 2023-10-20

Update dependency @types/chai-things to v0.0.37 [Self-hosted Renovate Bot]

odata-to-abstract-sql-6.1.1 - 2023-10-19

<summary> Update dependencies eslint, sbvrTypes, abstract-sql-compiler [Harald Fischer] </summary>

abstract-sql-compiler-9.0.3 - 2023-08-09

<summary> Update @balena/sbvr-types to 6.0.0 [Otávio Jacobi] </summary>

sbvr-types-6.0.0 - 2023-08-09

Change contents to snake_case [Otávio Jacobi]

sbvr-types-5.2.0 - 2023-08-08

Expose WebResource as WebResourceType [Otávio Jacobi]

sbvr-types-5.1.0 - 2023-08-03

Adds WebResource type [Otávio Jacobi]

abstract-sql-compiler-9.0.2 - 2023-05-16

<summary> Update @balena/sbvr-types to 5.0.0 [Pagan Gazzard] </summary>

sbvr-types-5.0.0 - 2023-05-16

Switch from export = to export default [Pagan Gazzard]

sbvr-types-4.0.2 - 2023-05-03

Improve typings [Pagan Gazzard]

sbvr-types-4.0.1 - 2023-05-02

boolean: Avoid unnecessary array creation to reduce GCs [Thodoris Greasidis]

abstract-sql-compiler-9.0.1 - 2023-05-15

Fix TS errors for the latest sbvrTypes [Thodoris Greasidis]

abstract-sql-compiler-9.0.0 - 2023-05-02

Drop require-npm4-to-publish as engines used [fisehara]

<summary> Update @balena/odata-to-abstract-sql to 6.x [Pagan Gazzard] </summary>

odata-to-abstract-sql-6.0.1 - 2023-04-27

<summary> Update dependencies [Pagan Gazzard] </summary>

odata-parser-3.0.0 - 2023-04-26

Use optional chaining operator [Pagan Gazzard]

Set minimum supported nodejs version to 16.13.0 [Pagan Gazzard]

odata-parser-2.5.0 - 2023-04-26

Update to peggy 3 and make us of the repetition operator [Pagan Gazzard]

sbvr-types-4.0.0 - 2023-04-26

Add test cases for Objects in JSON validate [fisehara]

Drop require-npm4-to-publish devDependency [fisehara]

Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]

Switch JSON to use JSON db type instead of TEXT [Pagan Gazzard]

Switch Boolean to use BOOLEAN db type instead of INTEGER [Pagan Gazzard]

Assert that JSON input typeof is object [Josh Bowling]

odata-to-abstract-sql-6.0.0 - 2023-04-26

Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]

Switch AggregateJSON to use the newer ReferencedField format [Pagan Gazzard]

odata-to-abstract-sql-5.9.6 - 2023-04-25

Collapse AliasedFunction into FunctionMatch [Pagan Gazzard]

odata-to-abstract-sql-5.9.5 - 2023-04-25

<summary> Improve typings [Pagan Gazzard] </summary>

abstract-sql-compiler-8.4.1 - 2023-04-25

Add much finer grained typings for abstract-sql-optimizer [Pagan Gazzard]

odata-to-abstract-sql-5.9.4 - 2023-04-24

<summary> Update dependencies [Pagan Gazzard] </summary>

abstract-sql-compiler-8.4.0 - 2023-04-24

Add support for using field type nodes with an AggregateJSON node [Pagan Gazzard]

abstract-sql-compiler-8.3.13 - 2023-04-24

Deprecate AliasableFromTypeNodes type as it's redundant [Pagan Gazzard]

abstract-sql-compiler-8.3.12 - 2023-04-17

Revert tightening of OrderBy to only field nodes [Pagan Gazzard]

abstract-sql-compiler-8.3.11 - 2023-04-13

Do not allow ON clauses for CROSS JOIN as it is invalid [Pagan Gazzard]

Stop accepting ExtractJSONPathAsText/ToJSON as unknown node types [Pagan Gazzard]

abstract-sql-compiler-8.3.10 - 2023-04-13

Fix DateNode/AnyNode typings [Pagan Gazzard]

abstract-sql-compiler-8.3.9 - 2023-04-13

<summary> Update dependencies [Pagan Gazzard] </summary>

# sbvr-types-3.5.0 - 2023-03-21

Add Big Serial type [Josh Bowling]

# sbvr-types-3.4.19 - 2022-12-08

Flowzone: Allow external contributions [Josh Bowling]

abstract-sql-compiler-8.3.8 - 2023-04-12

Improve typings [Pagan Gazzard]

abstract-sql-compiler-8.3.7 - 2023-04-12

Remove typing for non-existent JSON node [Pagan Gazzard]

abstract-sql-compiler-8.3.6 - 2023-04-12

Tighten the isXValue function typings [Pagan Gazzard]

abstract-sql-compiler-8.3.5 - 2023-04-12

Correctly treat Value nodes as rewritten to Text by the optimizer [Pagan Gazzard]

Add EmbeddedTextNode typing [Pagan Gazzard]

abstract-sql-compiler-8.3.4 - 2023-04-12

Enforce the first argument of ExtractJSONPathAsText is a JSON type node [Pagan Gazzard]

abstract-sql-compiler-8.3.3 - 2023-04-12

Improve node typings [Pagan Gazzard]

abstract-sql-compiler-8.3.2 - 2023-04-12

Add more node typings [Pagan Gazzard]

abstract-sql-compiler-8.3.1 - 2023-04-12

Add more node typings [Pagan Gazzard]

abstract-sql-compiler-8.3.0 - 2023-04-11

Support boolean nodes in a ValuesNode [Pagan Gazzard]

abstract-sql-compiler-8.2.0 - 2023-04-11

Add Between node type [Pagan Gazzard]

abstract-sql-compiler-8.1.0 - 2023-04-11

Add BitwiseAnd/BitwiseShiftRight node types [Pagan Gazzard]

abstract-sql-compiler-8.0.2 - 2023-04-06

Add NotInNode type [Pagan Gazzard]

Add IsDistinctFromNode/IsNotDistinctFromNode types [Pagan Gazzard]

Add CharacterLengthNode type [Pagan Gazzard]

abstract-sql-compiler-8.0.1 - 2023-04-06

Adds Cast node type to tree parsing [Otávio Jacobi]

odata-parser-2.4.6 - 2023-02-24

Improve typings [Pagan Gazzard]

odata-parser-2.4.5 - 2023-02-23

Use const/let as appropriate [Pagan Gazzard]

odata-parser-2.4.4 - 2023-02-23

Use shorthand object notation [Pagan Gazzard]

odata-parser-2.4.3 - 2023-02-23

Update dependencies [Pagan Gazzard]

Remove support for the legacy AggregateJSON format of [tableName, fieldName] [Pagan Gazzard]

Remove support for the legacy boolean format of true|false [Pagan Gazzard]

Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]

Remove support for the legacy alias format of [node, alias] [Pagan Gazzard]

Remove support for the legacy table format of tableName [Pagan Gazzard]

Remove support for the legacy null formats of null and 'Null' [Pagan Gazzard]

Reflect the usage of BOOLEAN db type [Pagan Gazzard]

<summary> Update @balena/sbvr-types to 4.x [Pagan Gazzard] </summary>

sbvr-types-4.0.0 - 2023-04-26

Add test cases for Objects in JSON validate [fisehara]

Drop require-npm4-to-publish devDependency [fisehara]

Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]

Switch JSON to use JSON db type instead of TEXT [Pagan Gazzard]

Switch Boolean to use BOOLEAN db type instead of INTEGER [Pagan Gazzard]

Assert that JSON input typeof is object [Josh Bowling]

abstract-sql-compiler-8.5.0 - 2023-04-27

Use native StartsWith node type for postgres [Pagan Gazzard]

Convert EscapeForLike into a standalone node type [Pagan Gazzard]

lf-to-abstract-sql-5.0.1 - 2023-05-16

<summary> Update @balena/sbvr-types to 5.0.0 [Pagan Gazzard] </summary>

sbvr-types-5.0.0 - 2023-05-16

Switch from export = to export default [Pagan Gazzard]

sbvr-types-4.0.2 - 2023-05-03

Improve typings [Pagan Gazzard]

sbvr-types-4.0.1 - 2023-05-02

boolean: Avoid unnecessary array creation to reduce GCs [Thodoris Greasidis]

sbvr-types-4.0.0 - 2023-04-26

Add test cases for Objects in JSON validate [fisehara]

Drop require-npm4-to-publish devDependency [fisehara]

Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]

Switch JSON to use JSON db type instead of TEXT [Pagan Gazzard]

Switch Boolean to use BOOLEAN db type instead of INTEGER [Pagan Gazzard]

Assert that JSON input typeof is object [Josh Bowling]

sbvr-types-3.5.0 - 2023-03-21

Add Big Serial type [Josh Bowling]

sbvr-types-3.4.19 - 2022-12-08

Flowzone: Allow external contributions [Josh Bowling]

odata-parser-3.0.1 - 2023-09-25

Allow running CI on external PRs [Pagan Gazzard]

sbvr-types-6.1.0 - 2023-10-03

Add checksum to WebResource [Otávio Jacobi]

sbvr-types-6.0.0 - 2023-08-09

Change contents to snake_case [Otávio Jacobi]

sbvr-types-5.2.0 - 2023-08-08

Expose WebResource as WebResourceType [Otávio Jacobi]

sbvr-types-5.1.0 - 2023-08-03

Adds WebResource type [Otávio Jacobi]

sbvr-types-5.0.0 - 2023-05-16

Switch from export = to export default [Pagan Gazzard]

sbvr-types-4.0.2 - 2023-05-03

Improve typings [Pagan Gazzard]

sbvr-types-4.0.1 - 2023-05-02

boolean: Avoid unnecessary array creation to reduce GCs [Thodoris Greasidis]

odata-to-abstract-sql-6.1.0 - 2023-08-16

Support bind references as boolean types [Pagan Gazzard]

sbvr-parser-1.4.6 - Invalid date

Update dependency @balena/sbvr-types to v8 [Self-hosted Renovate Bot]

sbvr-parser-1.4.5 - 2024-06-18

Switch to an inflection library from npm which does not monkey patch [Pagan Gazzard]

sbvr-parser-1.4.4 - 2024-03-05

Updated @balena/sbvr-types [Harald Fischer]

sbvr-types-9.0.2 - 2024-09-17

Change the exported Types to an interface so that they can be augmented [Thodoris Greasidis]

sbvr-types-9.0.1 - 2024-08-05

Update @balena/lint to v8.2.7 [Josh Bowling]

sbvr-types-9.0.0 - 2024-08-02

Update BigInteger and BigSerial TsTypes [Josh Bowling]

sbvr-types-8.0.0 - 2024-06-12

Improve BigInteger and BigSerial support [Josh Bowling]

sbvr-types-7.1.3 - 2024-06-12

Add typings for all abstract sql fragments, fixing where necessary [Pagan Gazzard]

sbvr-types-7.1.2 - 2024-06-12

Explicitly type the compare function for hashed [Pagan Gazzard]

sbvr-types-7.1.1 - 2024-06-04

Accept Date for the write types of Date Time/Date/Time [Pagan Gazzard]

sbvr-types-7.1.0 - 2024-04-25

Export typescript read/write types for each sbvr type [Pagan Gazzard]

sbvr-types-7.0.10 - 2024-04-09

Update Big Serial concept type to Big Integer [Josh Bowling]

sbvr-types-7.0.9 - 2024-04-09

Add Big Serial to Type.sbvr [Josh Bowling]

sbvr-types-7.0.8 - 2024-04-09

Update prepare script for husky v9 [Josh Bowling]

Update dependency husky to v9 [Self-hosted Renovate Bot]

sbvr-types-7.0.7 - 2024-04-09

Update dependency @balena/lint to v8 [Self-hosted Renovate Bot]

sbvr-types-7.0.6 - 2024-03-21

Improve JSON typings [Pagan Gazzard]

sbvr-types-7.0.5 - 2024-03-13

Remove unnecessary catch bindings [Pagan Gazzard]

sbvr-types-7.0.4 - 2024-03-13

Improve validate typings [Pagan Gazzard]

sbvr-types-7.0.3 - 2024-03-12

Improve fetchProcessing typings [Pagan Gazzard]

sbvr-types-7.0.2 - 2024-03-12

Tests: convert to typescript [Pagan Gazzard]

9.2.0 - 2024-06-12

Adds EndsWithNode and ContainsNode typings [Pagan Gazzard]

9.1.4 - 2024-04-09

Cast Big Serial to integer [Josh Bowling]

9.1.3 - 2024-04-09

Update prepare script for husky v9 [Josh Bowling]
Update dependency husky to v9 [Self-hosted Renovate Bot]

9.1.2 - 2024-04-09

Update dependency lint-staged to v15 [Self-hosted Renovate Bot]

9.1.1 - 2024-03-26

Update dependency @balena/lint to v8 [Thodoris Greasidis]

9.1.0 - 2024-03-26

Export the generateRuleHashAcronym helper [Thodoris Greasidis]
Add support for unique indexes with NOT DISTINCT NULLS [Thodoris Greasidis]
Add support for partial unique indexes [Thodoris Greasidis]

9.0.7 - 2024-03-22

<summary> Update dependency @balena/odata-parser to v3 [Self-hosted Renovate Bot] </summary>

odata-parser-3.0.3 - 2024-01-04

Optimize by moving constant values into global init [fisehara]

odata-parser-3.0.2 - 2024-01-04

Update dependencies [fisehara]

odata-parser-3.0.1 - 2023-09-25

Allow running CI on external PRs [Pagan Gazzard]

odata-parser-3.0.0 - 2023-04-26

Use optional chaining operator [Pagan Gazzard]

Set minimum supported nodejs version to 16.13.0 [Pagan Gazzard]

9.0.6 - 2024-03-21

Update TypeScript to 5.4.3 [Thodoris Greasidis]

9.0.5 - 2024-03-05

Update @balena/sbvr-types [Harald Fischer]

9.0.4 - 2024-01-02

Update dependency @types/node to v20 [Self-hosted Renovate Bot]

9.0.3 - 2023-08-09

<summary> Update @balena/sbvr-types to 6.0.0 [Otávio Jacobi] </summary>

sbvr-types-6.0.0 - 2023-08-09

Change contents to snake_case [Otávio Jacobi]

sbvr-types-5.2.0 - 2023-08-08

Expose WebResource as WebResourceType [Otávio Jacobi]

sbvr-types-5.1.0 - 2023-08-03

Adds WebResource type [Otávio Jacobi]

9.0.2 - 2023-05-16

<summary> Update @balena/sbvr-types to 5.0.0 [Pagan Gazzard] </summary>

sbvr-types-5.0.0 - 2023-05-16

Switch from export = to export default [Pagan Gazzard]

sbvr-types-4.0.2 - 2023-05-03

Improve typings [Pagan Gazzard]

sbvr-types-4.0.1 - 2023-05-02

boolean: Avoid unnecessary array creation to reduce GCs [Thodoris Greasidis]

9.0.1 - 2023-05-15

Fix TS errors for the latest sbvrTypes [Thodoris Greasidis]

9.0.0 - 2023-05-02

Drop require-npm4-to-publish as engines used [fisehara]

<summary> Update @balena/odata-to-abstract-sql to 6.x [Pagan Gazzard] </summary>

odata-to-abstract-sql-6.0.1 - 2023-04-27

<summary> Update dependencies [Pagan Gazzard] </summary>

odata-parser-3.0.0 - 2023-04-26

Use optional chaining operator [Pagan Gazzard]

Set minimum supported nodejs version to 16.13.0 [Pagan Gazzard]

odata-parser-2.5.0 - 2023-04-26

Update to peggy 3 and make us of the repetition operator [Pagan Gazzard]

sbvr-types-4.0.0 - 2023-04-26

Add test cases for Objects in JSON validate [fisehara]

Drop require-npm4-to-publish devDependency [fisehara]

Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]

Switch JSON to use JSON db type instead of TEXT [Pagan Gazzard]

Switch Boolean to use BOOLEAN db type instead of INTEGER [Pagan Gazzard]

Assert that JSON input typeof is object [Josh Bowling]

odata-to-abstract-sql-6.0.0 - 2023-04-26

Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]

Switch AggregateJSON to use the newer ReferencedField format [Pagan Gazzard]

odata-to-abstract-sql-5.9.6 - 2023-04-25

Collapse AliasedFunction into FunctionMatch [Pagan Gazzard]

odata-to-abstract-sql-5.9.5 - 2023-04-25

<summary> Improve typings [Pagan Gazzard] </summary>

abstract-sql-compiler-8.4.1 - 2023-04-25

Add much finer grained typings for abstract-sql-optimizer [Pagan Gazzard]

odata-to-abstract-sql-5.9.4 - 2023-04-24

<summary> Update dependencies [Pagan Gazzard] </summary>

abstract-sql-compiler-8.4.0 - 2023-04-24

Add support for using field type nodes with an AggregateJSON node [Pagan Gazzard]

abstract-sql-compiler-8.3.13 - 2023-04-24

Deprecate AliasableFromTypeNodes type as it's redundant [Pagan Gazzard]

abstract-sql-compiler-8.3.12 - 2023-04-17

Revert tightening of OrderBy to only field nodes [Pagan Gazzard]

abstract-sql-compiler-8.3.11 - 2023-04-13

Do not allow ON clauses for CROSS JOIN as it is invalid [Pagan Gazzard]

Stop accepting ExtractJSONPathAsText/ToJSON as unknown node types [Pagan Gazzard]

abstract-sql-compiler-8.3.10 - 2023-04-13

Fix DateNode/AnyNode typings [Pagan Gazzard]

abstract-sql-compiler-8.3.9 - 2023-04-13

<summary> Update dependencies [Pagan Gazzard] </summary>

sbvr-types-3.5.0 - 2023-03-21

Add Big Serial type [Josh Bowling]

sbvr-types-3.4.19 - 2022-12-08

Flowzone: Allow external contributions [Josh Bowling]

abstract-sql-compiler-8.3.8 - 2023-04-12

Improve typings [Pagan Gazzard]

abstract-sql-compiler-8.3.7 - 2023-04-12

Remove typing for non-existent JSON node [Pagan Gazzard]

abstract-sql-compiler-8.3.6 - 2023-04-12

Tighten the isXValue function typings [Pagan Gazzard]

abstract-sql-compiler-8.3.5 - 2023-04-12

Correctly treat Value nodes as rewritten to Text by the optimizer [Pagan Gazzard]

Add EmbeddedTextNode typing [Pagan Gazzard]

abstract-sql-compiler-8.3.4 - 2023-04-12

Enforce the first argument of ExtractJSONPathAsText is a JSON type node [Pagan Gazzard]

abstract-sql-compiler-8.3.3 - 2023-04-12

Improve node typings [Pagan Gazzard]

abstract-sql-compiler-8.3.2 - 2023-04-12

Add more node typings [Pagan Gazzard]

abstract-sql-compiler-8.3.1 - 2023-04-12

Add more node typings [Pagan Gazzard]

abstract-sql-compiler-8.3.0 - 2023-04-11

Support boolean nodes in a ValuesNode [Pagan Gazzard]

abstract-sql-compiler-8.2.0 - 2023-04-11

Add Between node type [Pagan Gazzard]

abstract-sql-compiler-8.1.0 - 2023-04-11

Add BitwiseAnd/BitwiseShiftRight node types [Pagan Gazzard]

abstract-sql-compiler-8.0.2 - 2023-04-06

Add NotInNode type [Pagan Gazzard]

Add IsDistinctFromNode/IsNotDistinctFromNode types [Pagan Gazzard]

Add CharacterLengthNode type [Pagan Gazzard]

abstract-sql-compiler-8.0.1 - 2023-04-06

Adds Cast node type to tree parsing [Otávio Jacobi]

odata-parser-2.4.6 - 2023-02-24

Improve typings [Pagan Gazzard]

odata-parser-2.4.5 - 2023-02-23

Use const/let as appropriate [Pagan Gazzard]

odata-parser-2.4.4 - 2023-02-23

Use shorthand object notation [Pagan Gazzard]

odata-parser-2.4.3 - 2023-02-23

Update dependencies [Pagan Gazzard]

Remove support for the legacy AggregateJSON format of [tableName, fieldName] [Pagan Gazzard]
Remove support for the legacy boolean format of true|false [Pagan Gazzard]
Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]
Remove support for the legacy alias format of [node, alias] [Pagan Gazzard]
Remove support for the legacy table format of tableName [Pagan Gazzard]
Remove support for the legacy null formats of null and 'Null' [Pagan Gazzard]
Reflect the usage of BOOLEAN db type [Pagan Gazzard]

<summary> Update @balena/sbvr-types to 4.x [Pagan Gazzard] </summary>

sbvr-types-4.0.0 - 2023-04-26

Add test cases for Objects in JSON validate [fisehara]

Drop require-npm4-to-publish devDependency [fisehara]

Set minimum supported nodejs version to 16.13.0 and tsconfig to es2021 [Pagan Gazzard]

Switch JSON to use JSON db type instead of TEXT [Pagan Gazzard]

Switch Boolean to use BOOLEAN db type instead of INTEGER [Pagan Gazzard]

Assert that JSON input typeof is object [Josh Bowling]

8.5.0 - 2023-04-27

Use native StartsWith node type for postgres [Pagan Gazzard]
Convert EscapeForLike into a standalone node type [Pagan Gazzard]

8.4.1 - 2023-04-25

Add much finer grained typings for abstract-sql-optimizer [Pagan Gazzard]

8.4.0 - 2023-04-24

Add support for using field type nodes with an AggregateJSON node [Pagan Gazzard]

8.3.13 - 2023-04-24

Deprecate AliasableFromTypeNodes type as it's redundant [Pagan Gazzard]

8.3.12 - 2023-04-17

Revert tightening of OrderBy to only field nodes [Pagan Gazzard]

8.3.11 - 2023-04-13

Do not allow ON clauses for CROSS JOIN as it is invalid [Pagan Gazzard]
Stop accepting ExtractJSONPathAsText/ToJSON as unknown node types [Pagan Gazzard]

8.3.10 - 2023-04-13

Fix DateNode/AnyNode typings [Pagan Gazzard]

8.3.9 - 2023-04-13

<summary> Update dependencies [Pagan Gazzard] </summary>

sbvr-types-3.5.0 - 2023-03-21

Add Big Serial type [Josh Bowling]

sbvr-types-3.4.19 - 2022-12-08

Flowzone: Allow external contributions [Josh Bowling]

8.3.8 - 2023-04-12

Improve typings [Pagan Gazzard]

8.3.7 - 2023-04-12

Remove typing for non-existent JSON node [Pagan Gazzard]

8.3.6 - 2023-04-12

Tighten the isXValue function typings [Pagan Gazzard]

8.3.5 - 2023-04-12

Correctly treat Value nodes as rewritten to Text by the optimizer [Pagan Gazzard]
Add EmbeddedTextNode typing [Pagan Gazzard]

8.3.4 - 2023-04-12

Enforce the first argument of ExtractJSONPathAsText is a JSON type node [Pagan Gazzard]

8.3.3 - 2023-04-12

Improve node typings [Pagan Gazzard]

8.3.2 - 2023-04-12

Add more node typings [Pagan Gazzard]

8.3.1 - 2023-04-12

Add more node typings [Pagan Gazzard]

8.3.0 - 2023-04-11

Support boolean nodes in a ValuesNode [Pagan Gazzard]

8.2.0 - 2023-04-11

Add Between node type [Pagan Gazzard]

8.1.0 - 2023-04-11

Add BitwiseAnd/BitwiseShiftRight node types [Pagan Gazzard]

8.0.2 - 2023-04-06

Add NotInNode type [Pagan Gazzard]
Add IsDistinctFromNode/IsNotDistinctFromNode types [Pagan Gazzard]
Add CharacterLengthNode type [Pagan Gazzard]

8.0.1 - 2023-04-06

Adds Cast node type to tree parsing [Otávio Jacobi]

8.0.0 - 2023-02-13

Add binds for affected IDs in compiled rules [Carol Schulze]

7.26.0 - 2023-02-07

Optimize schema during compilation [Carol Schulze]

7.25.3 - 2023-01-24

Wrap Date & Duration operations with parenthesis when necessary [Thodoris Greasidis]
Wrap composite math operations with parenthesis when necessary [Thodoris Greasidis]

7.25.2 - 2023-01-24

Tests: update @balena/odata-to-abstract-sql to 5.8 [Thodoris Greasidis]

7.25.1 - 2023-01-23

Change AggregateJSON to use JSON_AGG instead of ARRAY_TO_JSON+ARRAY_AGG [Pagan Gazzard]

7.25.0 - 2023-01-23

Add modifyFields/modifyName to table definition [Pagan Gazzard]

7.24.0 - 2023-01-16

Add the AbstractSql node Any [Carol Schulze]

7.23.0 - 2022-12-08

Add support for rules optimizations when using COUNT(*) = 0 [Pagan Gazzard]

7.22.5 - 2022-12-08

Flowzone: Allow external contributions [Josh Bowling]

7.22.4 - 2022-11-30

Fix: move @balena/odata-to-abstract-sql to dev dependencies [Pagan Gazzard]

7.22.3 - 2022-11-30

Tests: update @balena/odata-to-abstract-sql to 5.x [Pagan Gazzard]

7.22.2 - 2022-11-30

Fix deprecation notice module name [Pagan Gazzard]

7.22.1 - 2022-11-29

Add deprecation notices to the legacy null formats of null and 'Null' [Pagan Gazzard]
Add deprecation notice to the legacy table format of tableName [Pagan Gazzard]
Add deprecation notice to the legacy alias format of [node, alias] [Pagan Gazzard]

7.22.0 - 2022-11-23

Fix date fields used inside arithmetic expressions [fisehara]

7.21.1 - 2022-11-22

Add support for getting the modified fields of an aliased query [Pagan Gazzard]

7.21.0 - 2022-11-18

Add ToJSON/ExtractJSONPathAsText functions [Josh Bowling]

7.20.23 - 2022-11-18

Dev: Update pre-commit hook [Josh Bowling]

7.20.22 - 2022-11-18

Dev: Migrate husky setup for v8 [Josh Bowling]

7.20.21 - 2022-11-17

Update dependency husky to 8.0.2 [Renovate Bot]

7.20.20 - 2022-11-17

Dev: Move types to dev dependencies [Josh Bowling]

7.20.19 - 2022-11-17

Update @types/node from 10.17.60 to 18.11.9 [Josh Bowling]

7.20.18 - 2022-11-17

Update @types/lodash from 4.14.182 to 4.14.189 [Josh Bowling]

7.20.17 - 2022-11-17

Update @balena/sbvr-types from 3.4.7 to 3.4.8 [Josh Bowling]

7.20.16 - 2022-11-17

Update @balena/sbvr-parser from 1.4.1 to 1.4.2 [Josh Bowling]

7.20.15 - 2022-11-17

Update @balena/odata-parser from 2.2.9 to 2.4.2 [Josh Bowling]

7.20.14 - 2022-11-17

Update @balena/lf-to-abstract-sql from 4.5.1 to 4.5.2 [Josh Bowling]

7.20.13 - 2022-11-17

Update @balena/lint from 6.2.0 to 6.2.1 [Josh Bowling]

7.20.12 - 2022-11-17

Update lint-staged from 12.4.1 to 13.0.3 [Josh Bowling]

7.20.11 - 2022-11-17

Update chai from 4.3.6 to 4.3.7 [Josh Bowling]

7.20.10 - 2022-11-17

Update mocha from v9 to v10 [Josh Bowling]

7.20.9 - 2022-11-17

Update ts-node from 10.7.0 to 10.9.1 [Josh Bowling]

7.20.8 - 2022-11-17

Update typescript from 4.6.4 to 4.9.3 [Josh Bowling]

7.20.7 - 2022-11-17

CI: Split up abstract-sql tests [Josh Bowling]

7.20.6 - 2022-11-16

CI: Add more abstract-sql unit tests [Josh Bowling]

7.20.5 - 2022-11-16

Fix Right SQL generation [Josh Bowling]

7.20.4 - 2022-11-16

CI: Add several abstract-sql unit tests [Josh Bowling]

7.20.3 - 2022-11-15

Capitalize AggregateJSON SQL [Josh Bowling]

7.20.2 - 2022-11-11

Dev: Disable package-lock.json generation [Josh Bowling]

7.20.1 - 2022-10-14

Switch from balenaCI to flowzone [Pagan Gazzard]

7.20.0 - 2022-05-19

Expose isAliasNode helper [Pagan Gazzard]

7.19.1 - 2022-04-08

<summary> Update dependencies [Pagan Gazzard] </summary>

sbvr-types-3.4.7 - 2022-04-08

Update dependencies [Pagan Gazzard]

Remove circleci [Pagan Gazzard]

sbvr-types-3.4.6 - 2021-09-21

Avoid creating a new Date object when we already have one [Pagan Gazzard]

7.19.0 - 2022-03-24

Remove .circleci/config.yml [Thodoris Greasidis]
Add support for ConcatenateWithSeparator nodes [Thodoris Greasidis]

7.18.0 - 2022-02-16

Add reference property type [Harald Fischer]

7.17.1 - 2022-01-24

Avoid the operation type optimization for HAVING clauses [Pagan Gazzard]

7.17.0 - 2021-12-14

Add support for Count nodes in rule referenced fields [Pagan Gazzard]

7.16.0 - 2021-12-14

Add support for From nodes in rule referenced fields [Pagan Gazzard]

7.15.0 - 2021-12-13

Add support for HAVING clauses [Pagan Gazzard]

7.14.2 - 2021-12-13

Fix GroupByNode typings [Pagan Gazzard]

7.14.1 - 2021-09-23

Improve typing for LikeNode [Pagan Gazzard]

7.14.0 - 2021-09-13

Relax the restrictions on ORDER BY as it doesn't just allow fields [Pagan Gazzard]

7.13.5 - 2021-09-07

Update dependencies [Pagan Gazzard]

7.13.4 - 2021-08-17

Support for non postgres db engines [fisehara]

7.13.3 - 2021-07-28

Supprt date_trunc postgres date function for DateValue [fisehara]

7.13.2 - 2021-07-26

Update dependencies [Pagan Gazzard]

7.13.1 - 2021-06-30

Delete CODEOWNERS [Thodoris Greasidis]

7.13.0 - 2021-05-18

Add support for CurrentTimestamp/CurrentDate nodes [Pagan Gazzard]

7.12.7 - 2021-05-18

<summary> Update sbvr-types to 3.4.3 [Thodoris Greasidis] </summary>

sbvr-types-3.4.3 - 2021-05-11

Support boolean results from the db as well as integer [Pagan Gazzard]

7.12.6 - 2021-05-18

Allow duration seconds to be nullable [Pagan Gazzard]

7.12.5 - 2021-05-18

Re-enable all tests [Pagan Gazzard]

7.12.4 - 2021-05-04

Revert "Remove now unnecessary hack for casting SERIAL types" [Pagan Gazzard]

7.12.3 - 2021-05-03

Remove now unnecessary hack for casting SERIAL types [Pagan Gazzard]

7.12.2 - 2021-03-22

<summary> Update dependencies [Pagan Gazzard] </summary>

sbvr-types-3.4.2 - 2021-03-22

Update dev dependencies [Pagan Gazzard]

sbvr-types-3.4.1 - 2021-02-10

Remove unnecessary native fact type entries for synonymous forms [Pagan Gazzard]

sbvr-types-3.4.0 - 2021-02-08

Add a Current Time name that can be used to refer to the current time [Pagan Gazzard]

sbvr-types-3.3.0 - 2021-02-05

Add is before & is after verbs to the Date & DateTime types [Thodoris Greasidis]

sbvr-types-3.2.0 - 2021-01-29

Add support for the contains verb to the text type [Thodoris Greasidis]

Add support for theends with verb to the text type [Thodoris Greasidis]

Add support for the starts with verb to the text type [Thodoris Greasidis]

7.12.1 - 2021-03-22

Enable strict options by default and only disable specific ones [Pagan Gazzard]

7.12.0 - 2021-03-05

Enable narrowing down create/delete referenced fields for nested exists [Pagan Gazzard]

7.11.0 - 2021-03-01

Generalize/share the referenced fields code and cover more cases [Pagan Gazzard]

7.10.2 - 2021-02-12

Fix getModifiedFields for UpsertQuerys [Pagan Gazzard]

7.10.1 - 2021-01-29

Separate code relating to referenced fields out of the main file [Pagan Gazzard]

7.10.0 - 2021-01-29

Add an action property to modified fields of create/update/delete [Pagan Gazzard]
Automatically add ruleReferencedFields to SqlRules [Pagan Gazzard]
Add a getRuleReferencedFields which is tailored for rules [Pagan Gazzard]

7.9.1 - 2021-01-29

Add test for optimizeSchema optimizing rules [Pagan Gazzard]

7.9.0 - 2021-01-25

Optimize the abstract sql of rules when running optimizeSchema [Pagan Gazzard]

7.8.2 - 2021-01-15

Fix schema optimizations when table and resource names are different [Pagan Gazzard]

7.8.1 - 2021-01-04

Convert some lodash usage to native equivalents [Pagan Gazzard]

7.8.0 - 2021-01-01

Optimize Is[Not]DistinctFrom and [Not]Exists for non-null values [Pagan Gazzard]

7.7.0 - 2021-01-01

Optimize EXISTS/NOT EXISTS for empty queries [Pagan Gazzard]

7.6.0 - 2021-01-01

Optimize away AND/ORs with false/true respectively [Pagan Gazzard]

7.5.0 - 2021-01-01

Optimize out booleans from AND/OR where possible [Pagan Gazzard]

7.4.2 - 2020-12-21

Improve Relationship typings [Thodoris Greasidis]

7.4.1 - 2020-12-18

Fix containsNode when that node type is at the top level [Pagan Gazzard]

7.4.0 - 2020-12-18

Add support for table definitions [Pagan Gazzard]

7.3.0 - 2020-12-18

Allow compiling *QueryNodes to direct strings without binds [Pagan Gazzard]

7.2.1 - 2020-12-18

Improve typings for compilation results [Pagan Gazzard]

7.2.0 - 2020-12-16

Add an optimizeSchema function [Pagan Gazzard]

7.1.0 - 2020-12-09

Add check constraint support at the table level [Pagan Gazzard]

7.0.7 - 2020-12-09

Convert tests from coffeescript to type-checked javascript [Pagan Gazzard]

7.0.6 - 2020-11-30

Fix the NOT(NOT(...)) optimization [Pagan Gazzard]

7.0.5 - 2020-11-30

Remove some type casts [Pagan Gazzard]

7.0.4 - 2020-11-25

<summary> Update sbvr-types and make use of `castType` [Pagan Gazzard] </summary>

sbvr-types-3.1.2 - 2020-11-25

Add a castType property to type functions [Pagan Gazzard]

sbvr-types-3.1.1 - 2020-11-25

Update dependencies [Pagan Gazzard]

7.0.3 - 2020-10-02

Remove accidental necessity from the AbstractSqlField types [Pagan Gazzard]

7.0.2 - 2020-07-10

<summary> Update dependencies [Pagan Gazzard] </summary>

sbvr-types-3.1.0 - 2020-06-17

Update dependencies [Pagan Gazzard]

7.0.1 - 2020-07-10

Improve BindNode typing [Pagan Gazzard]

7.0.0 - 2020-05-21

Allow adding to the FromTypeNode set [Pagan Gazzard]
Rename to @balena/abstract-sql-compiler [Pagan Gazzard]
Improve typings [Pagan Gazzard]
Convert all returned promises to native promises instead of bluebird [Pagan Gazzard]
Update tsconfig to target es2018 [Pagan Gazzard]
Drop support for node 6/8 [Pagan Gazzard]

<summary> Update to @balena/sbvr-types 3.0.0 [Pagan Gazzard] </summary>

sbvr-types-3.0.0 - 2020-05-08

Convert fetchProcessing to synchronous functions [Pagan Gazzard]

Update to bcrypt 4.x [Pagan Gazzard]

Enable strict tsconfig [Pagan Gazzard]

Make use of import type where relevant [Pagan Gazzard]

Update to balena-lint 5.x [Pagan Gazzard]

Rename to @balena/sbvr-types [Pagan Gazzard]

Drop node 8 support [Pagan Gazzard]

Update tsconfig target to es2018 [Pagan Gazzard]

Convert all returned promises to native promises instead of bluebird [Pagan Gazzard]

6.13.6 - 2020-05-19

<summary> Update dependencies [Pagan Gazzard] </summary>

sbvr-parser-1.0.1 - 2020-05-11

Update to mocha 7.x [Pagan Gazzard]

sbvr-parser-1.0.0 - 2020-05-08

Convert coffeescript tests to javascript [Pagan Gazzard]

Drop support for node 6/8 [Pagan Gazzard]

Rename to @balena/sbvr-parser [Pagan Gazzard]

sbvr-parser-0.2.11 - 2020-05-08

CI: Add nodejs 14 to the test matrix [Pagan Gazzard]

CI: Remove circleci publishing in favor of balenaCI [Pagan Gazzard]

sbvr-parser-0.2.10 - 2020-05-08

Update to to @balena/sbvr-types [Pagan Gazzard]

sbvr-parser-0.2.9 - 2020-05-08

Update to @balena/lint 5.x [Pagan Gazzard]

sbvr-parser-0.2.8 - 2020-04-27

Reduce lodash usage [Pagan Gazzard]

lf-to-abstract-sql-4.0.0 - 2020-05-11

Include linting as part of the tests [Pagan Gazzard]

Convert from UMD module to commonjs module [Pagan Gazzard]

Rename to @balena/lf-to-abstract-sql [Pagan Gazzard]

Drop support for node 8 [Pagan Gazzard]

Move @balena/sbvr-parser to production dependencies [Pagan Gazzard]

lf-to-abstract-sql-3.2.6 - 2020-05-11

<summary> Update to @balena/sbvr-parser [Pagan Gazzard] </summary>

sbvr-parser-1.0.1 - 2020-05-11

Update to mocha 7.x [Pagan Gazzard]

sbvr-parser-1.0.0 - 2020-05-08

Convert coffeescript tests to javascript [Pagan Gazzard]

Drop support for node 6/8 [Pagan Gazzard]

Rename to @balena/sbvr-parser [Pagan Gazzard]

sbvr-parser-0.2.11 - 2020-05-08

CI: Add nodejs 14 to the test matrix [Pagan Gazzard]

CI: Remove circleci publishing in favor of balenaCI [Pagan Gazzard]

sbvr-parser-0.2.10 - 2020-05-08

Update to to @balena/sbvr-types [Pagan Gazzard]

sbvr-parser-0.2.9 - 2020-05-08

Update to @balena/lint 5.x [Pagan Gazzard]

sbvr-parser-0.2.8 - 2020-04-27

Reduce lodash usage [Pagan Gazzard]

lf-to-abstract-sql-3.2.5 - 2020-05-08

CI: Add nodejs 14 to the test matrix [Pagan Gazzard]

lf-to-abstract-sql-3.2.4 - 2020-05-08

<summary> Update to @balena/sbvr-types 3.0.0 [Pagan Gazzard] </summary>

sbvr-types-3.0.0 - 2020-05-08

Convert fetchProcessing to synchronous functions [Pagan Gazzard]

Update to bcrypt 4.x [Pagan Gazzard]

Enable strict tsconfig [Pagan Gazzard]

Make use of import type where relevant [Pagan Gazzard]

Update to balena-lint 5.x [Pagan Gazzard]

Rename to @balena/sbvr-types [Pagan Gazzard]

Drop node 8 support [Pagan Gazzard]

Update tsconfig target to es2018 [Pagan Gazzard]

Convert all returned promises to native promises instead of bluebird [Pagan Gazzard]

sbvr-types-2.0.9 - 2020-05-07

Switch to balena-lint [Pagan Gazzard]

sbvr-types-2.0.8 - 2020-05-05

Improve typings [Pagan Gazzard]

sbvr-types-2.0.7 - 2020-04-30

Remove unused imports [Pagan Gazzard]

sbvr-types-2.0.6 - 2020-04-27

Remove production lodash dependency [Pagan Gazzard]

lf-to-abstract-sql-3.2.3 - 2020-04-20

Switch to native some [Pagan Gazzard]

Switch to native findIndex [Pagan Gazzard]

Switch to native every [Pagan Gazzard]

Switch to native find [Pagan Gazzard]

Switch to native forEach where possible [Pagan Gazzard]

Switch to native includes [Pagan Gazzard]

Switch to native array type checking [Pagan Gazzard]

Switch to native string type checking [Pagan Gazzard]

Switch to native Object.assign [Pagan Gazzard]

lf-to-abstract-sql-3.2.2 - 2020-04-16

Always treat numbered terms as if they're used [Pagan Gazzard]

lf-to-abstract-sql-3.2.1 - 2020-04-14

<summary> Update dependencies [Pagan Gazzard] </summary>

sbvr-types-2.0.5 - 2020-03-17

CI: Remove circleci deploy in favor of balenaCI [Pagan Gazzard]

CI: Add node 12 to the test matrix [Pagan Gazzard]

CI: Remove node 6 from the test matrix [Pagan Gazzard]

Update dependencies and use resin-lint for automatic lint fixes [Pagan Gazzard]

sbvr-types-2.0.4 - 2020-01-22

Add node 12 to the test matrix [Pagan Gazzard]

Update dependencies [Pagan Gazzard]

Add CODEOWNERS [Pagan Gazzard]

sbvr-parser-0.2.7 - 2020-01-22

Add CODEOWNERS [Pagan Gazzard]

sbvr-parser-0.2.6 - 2019-12-30

Add support for using of instead of that is of [Pagan Gazzard]

sbvr-parser-0.2.5 - 2019-12-30

Add support for a given as a universal quantification [Pagan Gazzard]

sbvr-parser-0.2.4 - 2019-12-27

Allow including terms as part of a verb by using [] brackets [Pagan Gazzard]

lf-to-abstract-sql-3.2.0 - 2020-04-13

Only add the destination of a link table if it's actually necessary [Pagan Gazzard]

lf-to-abstract-sql-3.1.2 - 2020-02-26

CI: Remove circleci publishing in favor of balenaCI [Pagan Gazzard]

lf-to-abstract-sql-3.1.1 - 2020-01-22

Add CODEOWNERS [Pagan Gazzard]

lf-to-abstract-sql-3.1.0 - 2019-11-01

Add support for enum definitions on fact types [Pagan Gazzard]

lf-to-abstract-sql-3.0.2 - 2019-06-14

Fix updateModifiedAt formatting [Pagan Gazzard]

lf-to-abstract-sql-3.0.1 - 2019-05-08

Add node 12 tests [Pagan Gazzard]

Add repo.yml for upstream changelogs [Pagan Gazzard]

Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard]

lf-to-abstract-sql-3.0.0 - 2019-03-08

Add automatic modified at fields [Pagan Gazzard]

odata-parser-2.0.0 - 2020-05-11

Rename to @balena/odata-parser [Pagan Gazzard]

Update to @balena/lint 5.x [Pagan Gazzard]

Drop support for nodejs 8 [Pagan Gazzard]

CI: Add nodejs 14 to the test matrix [Pagan Gazzard]

CI: Remove circleci publishing in favor of balenaCI [Pagan Gazzard]

odata-to-abstract-sql-3.3.0 - 2019-06-07

<summary> Make use of odata-parser types [Pagan Gazzard] </summary>

odata-parser-1.1.1 - 2019-06-07

Improve typings [Pagan Gazzard]

odata-parser-1.1.0 - 2019-06-06

Add typings [Pagan Gazzard]

abstract-sql-compiler-6.6.0 - 2019-06-03

Improve aliased from handling in getReferencedFields [Pagan Gazzard]

abstract-sql-compiler-6.5.1 - 2019-06-03

Use an abstract-sql-optimiser prepass to simplify getReferencedFields [Pagan Gazzard]

sbvr-parser-0.2.3 - 2019-06-04

Optimise exactly 0 to not exists [Pagan Gazzard]

odata-to-abstract-sql-3.2.0 - 2019-05-31

Add support for computed fields [Pagan Gazzard]

odata-to-abstract-sql-3.1.3 - 2019-05-31

<summary> Unify the handling of adding fields with or without a $select [Pagan Gazzard] </summary>

odata-parser-1.0.4 - 2019-05-27

Fix adding parameter alias to the options object [Pagan Gazzard]

odata-parser-1.0.3 - 2019-05-08

Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard]

abstract-sql-compiler-6.5.0 - 2019-05-30

Add support for computed fields [Pagan Gazzard]

abstract-sql-compiler-6.4.3 - 2019-05-30

Add tests for getReferencedFields [Pagan Gazzard]

abstract-sql-compiler-6.4.2 - 2019-05-09

Update and fix lodash typings [Pagan Gazzard]

Update husky/mocha dev dependencies [Pagan Gazzard]

abstract-sql-compiler-6.4.1 - 2019-05-08

<summary> Fix typescript compilation [Pagan Gazzard] </summary>

sbvr-parser-0.2.2 - 2019-05-08

Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard]

Add node 12 tests [Pagan Gazzard]

Add repo.yml for upstream changelogs [Pagan Gazzard]

Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard]

odata-to-abstract-sql-3.1.2 - 2019-05-08

Add node 12 tests [Pagan Gazzard]

Add repo.yml for upstream changelogs [Pagan Gazzard]

Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard]

odata-to-abstract-sql-3.1.1 - 2019-04-22

Fix off-by-one error when having to resort to a random alias [Pagan Gazzard]

odata-to-abstract-sql-3.1.0 - 2019-03-08

Add support for definitions for the target table of insert queries [Pagan Gazzard]

Add path key where statements to the select subquery for inserts [Pagan Gazzard]

Convert == to === [Pagan Gazzard]

6.13.5 - 2020-05-07

<summary> Improve typing of `dataTypeValidate` and sbvr-types [Pagan Gazzard] </summary>

sbvr-types-2.0.9 - 2020-05-07

Switch to balena-lint [Pagan Gazzard]

sbvr-types-2.0.8 - 2020-05-05

Improve typings [Pagan Gazzard]

sbvr-types-2.0.7 - 2020-04-30

Remove unused imports [Pagan Gazzard]

sbvr-types-2.0.6 - 2020-04-27

Remove production lodash dependency [Pagan Gazzard]

6.13.4 - 2020-04-30

Reduce lodash usage [Pagan Gazzard]

6.13.3 - 2020-04-14

<summary> Update dependencies [Pagan Gazzard] </summary>

sbvr-types-2.0.5 - 2020-03-17

CI: Remove circleci deploy in favor of balenaCI [Pagan Gazzard]

CI: Add node 12 to the test matrix [Pagan Gazzard]

CI: Remove node 6 from the test matrix [Pagan Gazzard]

Update dependencies and use resin-lint for automatic lint fixes [Pagan Gazzard]

odata-parser-1.4.1 - 2020-04-10

Update dependencies [Pagan Gazzard]

odata-parser-1.4.0 - 2020-03-02

✨: Add support for canAccess method call on resource [Andreas Fitzek]

6.13.2 - 2020-03-25

📝♻️ : Improve RelationshipMapping typing and docs [Andreas Fitzek]

6.13.1 - 2020-02-26

Only create functions if they don't already exist [Pagan Gazzard]

6.13.0 - 2020-02-21

Add support for sum [Pagan Gazzard]
Add support for average [Pagan Gazzard]
Add tests for count [Pagan Gazzard]

6.12.0 - 2020-02-21

Add support for coalesce [Pagan Gazzard]

6.11.6 - 2020-02-21

<summary> Update dependencies [Pagan Gazzard] </summary>

sbvr-types-2.0.4 - 2020-01-22

Add node 12 to the test matrix [Pagan Gazzard]

Update dependencies [Pagan Gazzard]

Add CODEOWNERS [Pagan Gazzard]

6.11.5 - 2020-02-06

Update resin-lint to 3.x and use it for auto-linting [Pagan Gazzard]

6.11.4 - 2020-02-06

Fix query type check [Pagan Gazzard]

6.11.3 - 2020-01-22

Add CODEOWNERS [Pagan Gazzard]

6.11.2 - 2020-01-09

Trim trigger names to the max of 63 characters [Pagan Gazzard]

6.11.1 - 2019-11-22

Update dev dependencies [Pagan Gazzard]

6.11.0 - 2019-11-19

Add support for CrossJoin [Pagan Gazzard]

6.10.3 - 2019-11-19

Update dependencies [Pagan Gazzard]

6.10.2 - 2019-11-04

Fix CHECK syntax [Pagan Gazzard]

6.10.1 - 2019-11-04

Fix compileRule typings [Pagan Gazzard]

6.10.0 - 2019-11-04

Add support for basic check constraints [Pagan Gazzard]

6.9.2 - 2019-10-11

Allow combining/adding to existing NOT IN statements [Pagan Gazzard]
Allow combining/adding to existing IN statements [Pagan Gazzard]
Prioritise collapsing nested ANDs over converting them to an NOT IN [Pagan Gazzard]
Prioritise collapsing nested ORs over converting them to an IN [Pagan Gazzard]

6.9.1 - 2019-09-20

Switch to a lookup table for finding existing bind var entries [Pagan Gazzard]

6.9.0 - 2019-09-16

Add support for resolving directly circular dependencies on postgres [Pagan Gazzard]

6.8.1 - 2019-09-10

Optimise finding of existing binds when adding a bind variable [Pagan Gazzard]

6.8.0 - 2019-08-29

Add support for inner/left/right/full joins [Pagan Gazzard]

6.7.1 - 2019-06-17

Change IsDistinctFrom for postgres to a version that can use indexes [Pagan Gazzard]
Optimise IsDistinctFrom/IsNotDistinctFrom when either arg is Null [Pagan Gazzard]

6.7.0 - 2019-06-14

Add support for IsDistinctFrom/IsNotDistinctFrom [Pagan Gazzard]

6.6.0 - 2019-06-03

Improve aliased from handling in getReferencedFields [Pagan Gazzard]

6.5.1 - 2019-06-03

Use an abstract-sql-optimiser prepass to simplify getReferencedFields [Pagan Gazzard]

6.5.0 - 2019-05-30

Add support for computed fields [Pagan Gazzard]

6.4.3 - 2019-05-30

Add tests for getReferencedFields [Pagan Gazzard]

6.4.2 - 2019-05-09

Update and fix lodash typings [Pagan Gazzard]
Update husky/mocha dev dependencies [Pagan Gazzard]

6.4.1 - 2019-05-08

Fix typescript compilation [Pagan Gazzard]

<summary> View details </summary>

sbvr-parser-0.2.2 - 2019-05-08

Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard]

Add node 12 tests [Pagan Gazzard]

Add repo.yml for upstream changelogs [Pagan Gazzard]

Add .versionbot/CHANGELOG.yml for downstream changelogs [Pagan Gazzard]

6.4.0 - 2019-03-04

Add support for trigger functions [Pagan Gazzard]

6.3.6 - 2019-01-23

Fix FieldNodes being detected as deprecated aliases [Pagan Gazzard]

6.3.5 - 2019-01-22

Improve typings [Pagan Gazzard]

6.3.4 - 2018-12-07

Update to odata-to-abstract-sql v3.0.0 [Pagan Gazzard]

6.3.3 - 2018-11-23

Fix FromNode typing [Pagan Gazzard]

6.3.2 - 2018-11-21

Fix the deprecated implicit alias check to account for implicit tables [Pagan Gazzard]

6.3.1 - 2018-11-21

Support explicit table/alias nodes for the getXFields functions [Pagan Gazzard]

6.3.0 - 2018-11-20

Improve typings [Pagan Gazzard]

6.2.1 - 2018-11-16

Separate src/out dirs to avoid issues with importing .ts over .d.ts [Pagan Gazzard]

6.2.0 - 2018-11-15

Convert AbstractSQLOptimiser to typescript [Pagan Gazzard]
Convert AbstractSQLRules2SQL to typescript [Pagan Gazzard]

6.1.2 - 2018-11-13

Add resin-lint for typescript and a commit hook to run it [Pagan Gazzard]
Split the types for sbvr-types into a separate definition file [Pagan Gazzard]
Add resin-lint for coffee files [Pagan Gazzard]

6.1.1 - 2018-11-10

Optimise checking for aliases with a fast lookahead check [Pagan Gazzard]
Fix potentially incorrect And collapsing [Pagan Gazzard]

v6.1.0 - 2018-11-03

Switch to generating commonjs format [Pagan Gazzard]

v6.0.1 - 2018-10-25

Tighten alias/table name matches to strings [Pagan Gazzard]
Optimise the Select rule by removing redundant branches [Pagan Gazzard]

v6.0.0 - 2018-10-11

Update to sbvr-types 2.x [Pagan Gazzard]

v5.3.4 - 2018-10-04

Update lf-to-abstract-sql, updating tests to match [Pagan Gazzard]
Update dependencies [Pagan Gazzard]

v5.3.3 - 2018-08-13

Feature: Add support for CASE/WHEN/ELSE/END #35 [Rich Bayliss]

v5.3.2 - 2018-07-31

Don't try to merge IS NULL into an IN clause as it doesn't work #36 [Pagan Gazzard]

v5.3.1 - 2018-06-24

Make sure direct table names are strings, this avoid issues if parsing a SelectQuery fails. #33 [Pagan Gazzard]

v5.3.0 - 2018-06-14

Allow reusing bind parameters for the postgres backend rather than duplicating for each instance. #32 [Pagan Gazzard]

v5.2.1 - 2018-06-09

Update lf-to-abstract-sql and fix tests. #31 [Pagan Gazzard]

v5.2.0 - 2018-06-08

Add support for string bind keys #30 [Pagan Gazzard]

v5.1.2 - 2018-06-04

Fix test.skip/test.only/etc for the sbvr tests #28 [Pagan Gazzard]

v5.1.1 - 2018-06-04

Update dependencies #29 [Pagan Gazzard]

v5.1.0 - 2018-06-01

Change CONTAINS to use LIKE instead of STRPOS. #27 [Pagan Gazzard]
Change EndsWith to use LIKE instead of RIGHT to avoid duplicating the needle. #27 [Pagan Gazzard]
Change StartsWith to use LIKE instead of STRPOS so that it can make better use of indexes. #27 [Pagan Gazzard]

v5.0.4 - 2018-05-10

Update dependencies #25 [Pagan Gazzard]

v5.0.3 - 2018-05-10

Switch types to using generated declaration files, this avoids issues with the typescript code being rechecked downstream. #26 [Pagan Gazzard]

v5.0.2 - 2018-05-10

Require npm 4+ to publish, to avoid issues with publishing #24 [Pagan Gazzard]

v5.0.1 - 2018-04-30

Add node 10 to the circleci tests #23 [Pagan Gazzard]
Move circle.yml to .circleci/config.yml #23 [Pagan Gazzard]

v5.0.0 - 2018-04-25

Change the references format to expect a resourceName rather than a tableName #22 [Pagan Gazzard]

v4.1.1 - 2018-04-25

Update tests to use odata-to-abstract-sql 1.2.0 #21 [Pagan Gazzard]

v4.1.0 - 2018-04-23

Support the Or -> In optimisation for cases where you have mixed comparisons in an or block, allowing it to be used in a lot more cases. #19 [Pagan Gazzard]
Make sure the nested or optimisation hits the validator method directly, avoiding other optimisations breaking it. #19 [Pagan Gazzard]

v4.0.0 - 2018-04-11

Generate numbered bindings for postgres rather than ? #17 [Pagan Gazzard]

v3.3.0 - 2018-01-05

Add support for union queries. #16 [Pagan Gazzard]

v3.2.2 - 2018-01-05

Update dependencies #15 [Pagan Gazzard]

v3.2.1 - 2017-12-11

Lock types versions and fix type errors. #14 [Pagan Gazzard]
Set up circleci auto-publishing #14 [Pagan Gazzard]

v3.2.0 - 2017-10-24

Updated dependencies and rewrote tests to account for breaking changes #12 [Giovanni Garufi]

v3.1.0 - 2017-10-02

Convert AbstractSQLCompiler to typescript and add typings for the OMeta parts #11 [Pagan Gazzard]
Added versionist #11 [Giovanni Garufi]

v3.0.0

Changed API to pass rule bindings along with the compiled query.

v2.3.3

Fixed checking for unresolved dependencies

v2.3.2

Fixed checking of dependencies when there is self-reference for a resource where the resource name and table name are different

v2.3.1

Fixed added referenced fields to rules

v2.3.0

Add getReferencedFields and getModifiedFields functions.
Add referencedFields info to compiled rules.
Update coffeescript to ~1.12.6

v2.2.0

Added support for numbered binds.
Added a test for a self-referential expand (pilot?$expand=pilot)

v2.1.0

Added a test for a rule with numbered terms.
Added some tests from the sbvr-parser that were missing here.
Added a non-primitive concept type test to the pilots tests.
Added support for $count
Added tests for $count
Updated the client model for tests
Updated tests

v2.0.0

Stopped treating an empty string as null.

v1.2.0

Added support for duration literals.
Added support for Contains, Now, Year, Month, Day, Hour, Minute, Second, FractionalSeconds, ToDate, ToTime, and TotalSeconds.
Avoided issues with wildchard characters in Substringof, StartsWith, and EndsWith.
Fixed InStr and IndexOf.
Updated the sbvr model for tests.

v1.1.0

AggregateJSON now returns an empty array instead of null in the case of zero results.
Updated to lodash 4

v1.0.2

Update ometa-js

v1.0.1

Correctly adjust INSTR/STRPOS, INSTR is the zero-indexed one!
Change startswith and endswith from (needle, haystack) to (haystack, needle), to match the OData spec.
Updated to bluebird 3.

v0.4.2

Update @resin/odata-to-abstract-sql to ~0.3.0, adding matching tests.

v0.4.1

Fixed requirejs import path.

v0.4.0

Added support for specifying a defaultValue for a field.
Added schema generation support.
Changed the exported compile(engine, abstractSQL) function to [engine].compileRule(abstractsql)

v0.3.2

Fixed an issue with auto incrementing fields of websql/mysql.

v0.3.1

Updated lodash to ^3.0.0
Updated sbvr-types to v0.1.1

v0.3.0

Updated sbvr-types to v0.1.0
Updated lodash to ~3.0.0

v0.2.1

Optimised not exists statements.
Added tests for true/false.
Added support for 'Null' as well as null for null valus.
Changed comparisons against null to use IS NULL/IS NOT NULL

v0.2.0

Switch to using bind vars for embedded number/text values.
Switched to using multiple part UPSERT queries, allowing greater flexibility.
Simplified NULL handling.

v0.1.1

Added support for CAST.

v0.1.0

Added support for select queries in the values clause.

https://yarn.pm/@balena/abstract-sql-compiler

balena-io-modules/abstract-sql-compiler

@balena/abstract-sql-compiler

Use it

$ yarn add @balena/abstract-sql-compiler

Try in RunKit · Browse Files

CDNs

jsDelivr: cdn.jsdelivr.net/npm/@balena/abstract-sql-compiler/
unpkg: unpkg.com/@balena/abstract-sql-compiler/
bundle.run: bundle.run/@balena/abstract-sql-compiler

Popularity

GitHub stargazers: 0
Downloads last 30 days: 45.3k
jsDelivr last 30 days: 0
Dependents: 0

Usage

Dependencies: 0
DevDependencies @balena/lf-to-abstract-sql, @balena/lint, @balena/odata-parser, @balena/odata-to-abstract-sql, @balena/sbvr-parser, @types/chai, @types/common-tags, @types/lodash, @types/mocha, @types/node, chai, common-tags, husky, lint-staged, lodash, mocha, ts-node, typescript: 18
Packages: see package.json
Size in browser: 55.66KB

Versions

July 14, 2025: 10.6.0
July 14, 2025: 10.6.0-build-abstract-sql-contains-node-92e7d4dd97329fb93e2f1c27b275c9cc38ab74c5-1
July 9, 2025: 10.5.2-build-joshbwlng-order-columns-a3e130d1545ce1ff41d67fb2d7640ded7417cadd-1