@balena/abstract-sql-to-typescript - npm Package Versions

1.2.1 - 2022-10-14

• Switch from balenaCI to flowzone [Pagan Gazzard]

1.2.0 - 2022-04-15

• Add support for reverse references using relationships info [Pagan Gazzard]

1.1.2 - 2022-04-08

odata-to-abstract-sql-5.4.9 - 2022-04-08

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

abstract-sql-compiler-7.19.0 - 2022-03-24

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

abstract-sql-compiler-7.18.0 - 2022-02-16

• Add reference property type [Harald Fischer]

abstract-sql-compiler-7.17.1 - 2022-01-24

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

odata-parser-2.2.9 - 2022-04-08

• Update dependencies [Pagan Gazzard]
• Remove circleci [Pagan Gazzard]

</details>

• Remove circleci [Pagan Gazzard]

odata-to-abstract-sql-5.4.8 - 2022-01-13

• Use the full alias for the prefix hash [Pagan Gazzard]

odata-to-abstract-sql-5.4.7 - 2022-01-11

• Use a hash instead of random str when it's necessary to shorten aliases [Pagan Gazzard]

odata-to-abstract-sql-5.4.6 - Invalid date

• Improve ResourceFunction typings [Pagan Gazzard]

odata-to-abstract-sql-5.4.5 - 2021-11-26

• Fix isBindReference check for non-null non-object types [Pagan Gazzard]

odata-to-abstract-sql-5.4.4 - 2021-09-07

• Convert tests to type checked javascript [Pagan Gazzard]

odata-to-abstract-sql-5.4.3 - 2021-08-24

<details> <summary> Add SBVR Date TIme Type to DateTrunc Wrapper JS Date format has only milliseconds precision, postgresql stores TIMESTAMPS with microseconds precission. Comparisions may fail, when giving millisecond JS dates but comparing on microseconds. [fisehara] </summary>

abstract-sql-compiler-7.13.4 - 2021-08-17

• Support for non postgres db engines [fisehara]

abstract-sql-compiler-7.13.3 - 2021-07-28

• Supprt date_trunc postgres date function for DateValue [fisehara]

abstract-sql-compiler-7.13.2 - 2021-07-26

• Update dependencies [Pagan Gazzard]

abstract-sql-compiler-7.13.1 - Invalid date

• Delete CODEOWNERS [Thodoris Greasidis]

abstract-sql-compiler-7.13.0 - 2021-05-18

• Add support for CurrentTimestamp/CurrentDate nodes [Pagan Gazzard]

abstract-sql-compiler-7.12.7 - 2021-05-18

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

</details>

abstract-sql-compiler-7.12.6 - 2021-05-18

• Allow duration seconds to be nullable [Pagan Gazzard]

abstract-sql-compiler-7.12.5 - 2021-05-18

• Re-enable all tests [Pagan Gazzard]

abstract-sql-compiler-7.12.4 - 2021-05-04

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

abstract-sql-compiler-7.12.3 - 2021-05-03

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

abstract-sql-compiler-7.12.2 - 2021-03-22

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

</details>

abstract-sql-compiler-7.12.1 - 2021-03-22

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

abstract-sql-compiler-7.12.0 - 2021-03-05

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

abstract-sql-compiler-7.11.0 - 2021-03-01

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

abstract-sql-compiler-7.10.2 - 2021-02-12

• Fix getModifiedFields for UpsertQuerys [Pagan Gazzard]

abstract-sql-compiler-7.10.1 - 2021-01-29

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

abstract-sql-compiler-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]

abstract-sql-compiler-7.9.1 - 2021-01-29

• Add test for optimizeSchema optimizing rules [Pagan Gazzard]

abstract-sql-compiler-7.9.0 - 2021-01-25

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

abstract-sql-compiler-7.8.2 - 2021-01-15

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

abstract-sql-compiler-7.8.1 - 2021-01-04

• Convert some lodash usage to native equivalents [Pagan Gazzard]

abstract-sql-compiler-7.8.0 - 2021-01-01

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

abstract-sql-compiler-7.7.0 - 2021-01-01

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

abstract-sql-compiler-7.6.0 - 2021-01-01

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

abstract-sql-compiler-7.5.0 - 2021-01-01

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

</details>

odata-to-abstract-sql-5.4.2 - Invalid date

• Delete CODEOWNERS [Thodoris Greasidis]