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
<details> <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]

</details>
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
<details> <summary> Update dependencies eslint, sbvrTypes, abstract-sql-compiler [Harald Fischer] </summary>

abstract-sql-compiler-9.0.3 - 2023-08-09
<details> <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]

</details>
abstract-sql-compiler-9.0.2 - 2023-05-16
<details> <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]

</details>
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]
<details> <summary> Update @balena/odata-to-abstract-sql to 6.x [Pagan Gazzard] </summary>

odata-to-abstract-sql-6.0.1 - 2023-04-27
<details> <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]

</details>
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
<details> <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]

</details>
odata-to-abstract-sql-5.9.4 - 2023-04-24
<details> <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
<details> <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]

</details>
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]

</details>
</details>
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]
<details> <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]

</details>
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
<details> <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]

</details>
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]

</details>
odata-to-abstract-sql-6.1.0 - 2023-08-16

Support bind references as boolean types [Pagan Gazzard]

odata-to-abstract-sql-6.0.1 - 2023-04-27
<details> <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]

</details>
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]

</details>