github neilotoole/sq v0.55.0

5 hours ago

Added

  • [#986]: sq driver ls with -j / -y now reports an is_embedded_sql field for each driver, true for the in-process SQL drivers (SQLite, DuckDB) and false for the networked engines (including rqlite, which is SQLite-backed but reached over HTTP) and non-SQL drivers.

Changed

  • ☢️ [#1136]: In JSON output, a backspace or form feed inside a string value is now written using its two-character short escape instead of the six-character numeric escape. This aligns sq with the behavior of encoding/json since Go 1.22. Both spellings decode to the same string, so anything that parses sq's JSON is unaffected, and only output containing one of those two characters changes at all. Stored fixtures, golden files or checksums that compare sq's JSON byte-for-byte may need regenerating.

Fixed

  • [#975]: A join across two sources could fail with database is locked when large tables were copied into the temporary join database.
  • [#1017]: A canceled or failed table copy or ingest could commit a partially-written table instead of rolling back.
  • [#976], [#994]: The DuckDB driver now correctly quotes table, column, and schema names that contain a double quote (e.g. a we"ird table created from a CSV header), completing the identifier-quoting fix [#821] applied to SQLite and rqlite.
  • [#968]: Aligned the SQLite and DuckDB Sakila test fixtures with the canonical schema used by the other drivers.

Don't miss a new sq release

NewReleases is sending notifications on new releases.