github.com/mithrandie/csvq

Release 1.17.11

• Prevent divide-by-zero error while loading csv files. (GitHub #89)
• Handle panics during processor executions.

Release v1.17.10

• Fix a bug when loading views from cache.

Release v1.17.9

• Sort the command options displayed in the help message. (GitHub #80)
• Fix some bugs.

Release v1.17.8

• Allow URLs and Table identification functions to be used as table identifiers.

Release v1.17.8-pr.1

• Allow URLs and Table identified functions to be used as tableidentifiers.

Release v1.17.7

• Add system defined constants.
• Add the command option –scientific-notation.
• Handle NaN and Infinity.
• Add several numeric and datetime functions.
• Fix some bugs.

Release v1.17.6

• Fix a bug in REPLACE query. (GitHub #79)

Release v1.17.6-pr.1

Update the version of github.com/urfave/cli to v2.

Released on Jun 26, 2022

• Fix a bug of the CASE expression. (GitHub #78)

Released on Jun 25, 2022

• Add the IF NOT EXISTS clause to the syntax of the CREATE TABLE statement. (GitHub #77)

Released on Jun 19, 2022

• Set the default format to csv when the output is piped. (GitHub #71)

Released on Jun 17, 2022

• Allow analytic functions to be used as operands in expressions. (GitHub #36)
• Set output format from file extension. (GitHub #76)

Released on May 3, 2022

• Support column name wildcard for tables. (GitHub #68)
• Add a string function.
  • TITLE_CASE (GitHub #48)
• Modify integer and float handling.
  • Fixed a bug in the conversion between integer and float.
  • Intuitive handling of integer and float.
  • Allow exponential notation for float.

Released on Feb 26, 2022

• Support JSON Lines format. (GitHub #58)
• Support BOX format as an export format. (GitHub #61)

Released on June 13, 2021

• Allow empty key names in JSON output. (GitHub #57)
• Fix a bug of the "--allow-uneven-fields" option. (GitHub #59)

Released on May 5, 2021

• Allow same table names on both sides of set operators. (GitHub #53)
• Add the command option "--allow-uneven-fields". (GitHub #54)
• Fix a bug in parsing of set operations.

Released on March 28, 2021

• Add regular expression functions.
  • REGEXP_MATCH
  • REGEXP_FIND
  • REGEXP_FIND_SUBMATCHES
  • REGEXP_FIND_ALL
  • REGEXP_REPLACE
• Add Table-Valued functions.
  • CSV_INLINE
  • JSON_INLINE

Released on March 21, 2021

• Fix a bug of dual table. (GitHub #49)

Released on March 9, 2021

• Add the second argument to the DATETIME function to specify the time zone. (GitHub #43)
• Interpret date and time strings as strings instead of converting them to DATETIME values when parsing.
• Add the following items to the configuration file.
  • timezone
  • ansi_quotes

Released on January 31, 2021

• Fix a bug in the "--import-format" option. (Github #41)

Released on November 23, 2020

• Add the command option "--strict-equal".

Released on September 5, 2020

• Enclose csv values containing double-quotes automatically. (Github #37)

Tagged for Ubuntu PPA. No changes to the behavier.

Released on May 22, 2020

• Change reference scope in lateral subquery. (Github #30)

Released on May 20, 2020

• Support LATERAL join. (Github #24)
• Support USING join condition in FULL OUTER JOIN.
• Support $XDG_CONFIG_HOME environment variable for configuration files.

Released on April 11, 2020

• Ignore all leading and trailing white spaces of the field name when specifying a field name.

Released on February 4, 2020

• Fix a bug that arrow keys do not work in the interactive shell on Windows. (Github #26)

Released on January 15, 2020

• Fix a bug of LIKE operator.

Released on January 14, 2020

• Fix a bug of LIKE operator. (Github #25)