v0.32.0
Added
-
#187: For
csv
sources,sq
will now try to auto-detect if the CSV file
has a header row or not. Previously, this needed to be explicitly specified
via an awkward syntax:$ sq add ./actor.csv --opts=header=true
This change makes working with CSV files significantly lower friction.
A command like the below now almost always works as expected:$ cat ./actor.csv | sq .data
Support for Excel/XLSX header detection is in #191.
Fixed
-
sq
is now better at detecting the (data) kind of CSV fields. It now more
accurately distinguishes betweenDecimal
andInt
, and knows how to
handleDatetime
. -
#189:
sq
now treats CSV empty fields asNULL
.