neilotoole/sq v0.36.0

on GitHub

The major feature is the long-gestating sq diff.

Added

• #229: sq diff compares two sources, or tables.
• sq inspect --dbprops is a new mode that returns only the DB properties.
  Relatedly, the properties mechanism is now implemented for all four supported
  DB types (previously, it was only implemented for Postgres and MySQL).
• CSV format now colorizes output.

Changed

• sq inspect -v previously returned DB properties in a field named db_variables.
  This field has been renamed to db_properties. The renaming reflects the fact
  that some of those properties aren't really variables in the sense that they
  can be modified (e.g. DB server version or such).
• The structure of the former db_variables (now db_properties) field has
  changed. Previously it was an array of {"name": "XX", "value": "YY"} values,
  but now is a map, where the keys are strings, and the values can be either
  a scalar (bool, int, string, etc.), or a nested value such as an array
  or map. This change is made because some databases (e.g. SQLite) feature
  complex data in some property values.
• CSV format now renders byte sequences as [777 bytes] instead of dumping
  the raw bytes.
• ☢️ TSV format (--tsv) no longer has a shorthand form -T. Apparently that
  shorthand wasn't used much, and -T is needed elsewhere.
• ☢️ Likewise, --xml no longer has shorthand -X. And --markdown has lost alias --md.
• In addition to the format flags --text, --json, etc., there is now
  a --format=FORMAT flag, e.g. --format=json. This will allow sq to
  continue to expand the number of output formats, without needing to have
  a dedicated flag for each format.