v2.1.0

Changes from v2.0.0:

• Add index argument to op.match().
• Fix table indices() to properly handle order argument.
• Fix fromJSON() auto-type parsing of integer strings.
• Fix fromArrow() handling of FixedSizeList columns.

v2.0.0

Changes from v1.3.1:

• Breaking: Add schema metadata to fromJSON() and toJSON().
• Breaking: Add drop option to spread() verb to drop input columns, set default to true.
• Breaking: Revise spread() to use undefined for missing values.
• Breaking: Revise spread() to use _ separator between column name and index number in auto-generated names.
• Breaking: Revise spread() to use the length of the as option as an implicit limit when limit is unspecified.
• Breaking: Revise pivot() to place value name before key name when multiple values are specified.
• Breaking: Consolidate internal Query and QueryBuilder classes.
• Add impute() verb.
• Add column reference checks to pivot() and rollup().
• Add more flexible join key specification for lookup().
• Update sample() weight calculation to drop unneeded columns.
• Update verb JSDoc comments / TypeScript types.
• Fix input type checks for sequence op functions.
• Fix code generation for safer output.
• Refactor: Expose row_number op for internal use.
• Refactor: Update expression parser error messages.
• Refactor: Add Transformable base class for both Table and Query.
• Refactor: Update ColumnTable constructor.

v1.3.1

Changes from v1.3.0:

• Fix reify() to persist column name order.
• Fix rollup() to handle empty input. (#64)
• Fix distinct aggregate to use standard key function.
• Refactor: Use op methods internally.
• Refactor: Refine concat() early exit criteria.
• Refactor: Refine dedupe() implementation.
• Refactor: Use aggregate result arrays, not objects.
• Clean JSDoc for optional options.

v1.3.0

Changes from v1.2.3:

• Add fill_down and fill_up window functions.
• Add boolean drop option to derive() verb to drop original columns and retain derived columns only.
• Add support for pre-filtered Apache Arrow tables.
• Add flexible column selection for Apache Arrow import.
• Add TypeScript types to build output, compiled from JSDoc comments. (thanks @dworthen!)
• Fix internal column name handling to properly order integer-named columns.
• Fix op.match to use the proper string match method.
• Fix JSDoc types to use object, not Object.

v1.2.3

Changes from v1.2.2:

• Consistently handle empty/null input to non-count aggregates, return undefined.
• Handle undefined input to toString().

v1.2.2

Changes from v1.2.1:

• Fix extraction of nested null values in fromArrow().

v1.2.1

Changes from v1.2.0:

• Fix relocate() logic bug.

v1.2.0

Changes from v1.1.1:

• Add relocate() verb for repositioning and renaming columns.
• Add derive() verb before and after options to position new derived columns.
• Add matches(), startswith(), endswith() selection helpers.
• Add op.recode() function to map input values to recoded values.
• Add limit and offset arguments to table scan() method.
• Add List and Struct type support to fromArrow(). Extracts nested values to arrays and objects, respectively.
• Add offset option for output formats such as toCSV(), toHTML(), etc.
• Add null option to toHTML() to specialize formatting of null and undefined values.

v1.1.1

Changes from v1.1.0:

• Fix semijoin and antijoin to use the same join key syntax as join, join_left, etc.
• Update join documentation, including jsdoc comments.

v1.1.0

Changes from v1.0.0:

• Update join to drop paired key columns that share the same name. Previously, both columns would by default be retained with suffixes appended (e.g., 'key_1', 'key_2'). In the case of full outer joins, shared key columns will be merged as needed.
• Add support for one-sided join key specifications:
  • join(table, 'key') is now equivalent to join(table, ['key', 'key'])
  • join(table, [['key1', 'key2']]) is now equivalent to join(table, [['key1', 'key2'], ['key1', 'key2']])
• Add BigInt support, including for sum, product, median, and quantile aggregation functions.
• Fix product aggregation streaming (windowed) behavior.
• Fix unique aggregation streaming (windowed) behavior.
• Fix hash-join logic to properly handle filtered tables.
• Refactor join methods to reuse setup and output logic.