v0.36.0
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 nameddb_variables
.
This field has been renamed todb_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
(nowdb_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 allowsq
to
continue to expand the number of output formats, without needing to have
a dedicated flag for each format.