CHANGELOG.md

v2.8.0 (2017-02-12)

• aliases now accessible in WHERE and GROUP BY:
  • SELECT field AS alias WHERE alias = 123
  • SELECT field AS alias GROUP BY alias

v2.7.0 (2017-02-08)

• NOT IN and NOT STRICT IN
• Way to bind pluggable data transfors

v2.6.0 (2017-01-27)

• Multiline JSON objects are supported

v2.5.0 (2017-01-23)

• REGEXP support: "string" REGEXP "/pattern/im"
• BETWEEN support
• IS support:
  • IS [NOT] NULL
  • IS [NOT] BOOL and alias IS [NOT] BOOLEAN
  • IS [NOT] NUMBER
  • IS [NOT] ARRAY
  • IS [NOT] OBJECT
  • IS [NOT] STRING

v2.4.0 (2017-01-20)

• LIKE and ILIKE (case-insensitive LIKE) was added
• Automatical type coercion in date comparisons like ts > NOW() - INTERVAL 1 DAY

v2.3.0 (2017-01-19)

• SELECT ... FROM dataSource support
• JSON objects can now be created as {key: "value"} not only JSON-compliant form {"key": "value"}

v2.2.0 (2017-01-01)

• New aggregation function: AVG()

v2.1.0 (2016-12-22)

• Arrays now supports multi-value bindings: SELECT [1, 2, ::other, 3]

v2.0.0 (2016-12-21)

Breaking changes:

• Identifier binding syntax changed: [:bind] -> {:bind}
• INSERT row1[, row2...] syntax changed to INSERT VALUES row1[, row2...]

New features:

• Bindings and column values in JSON: SELECT {"column": columnName, "binded": :bind}
• INSERT now supports bindings

v1.5.0 (2016-12-20)

• SELECT DISTINCT ... support
• SELECT COUNT(DISTINCT ...) support

v1.4.0 (2016-12-14)

• Added support for constant JSON-values
• Support for DELETE WHERE queries
• Support for INSERT {object}[,{object}] queries. Rows just was aded to end of the input stream
• Support for UPDATE queries
• Added support for E-notation for floating numbers
• Support for SELECT *, [fields...]

v1.3.0 (2016-12-05)

• Added the ability to manipulate dates using the INTERVAL operators
• DATE() now return dates in local timezone instead of UTC

v1.2.0 (2016-12-03)

• Binding can now be used for data sources (JOIN [:name] ON @name.field = field)
• Sorting strings are now always done in byte-by-byte representation of the string in UTF-8. Made to be compatible with the sorting of sort

v1.1.0 (2016-12-01)

New features:

• Identifiers binding (#1)