Added
- [#986]:
sq driver lswith-j/-ynow reports anis_embedded_sqlfield for each driver,truefor the in-process SQL drivers (SQLite, DuckDB) andfalsefor 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
sqwith the behavior ofencoding/jsonsince Go 1.22. Both spellings decode to the same string, so anything that parsessq's JSON is unaffected, and only output containing one of those two characters changes at all. Stored fixtures, golden files or checksums that comparesq's JSON byte-for-byte may need regenerating.
Fixed
- [#975]: A join across two sources could fail with
database is lockedwhen 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"irdtable 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.