)

Three behavior-preserving cleanups:

1. Extract visual.zig — Shared UTF-8 display-width module (visualWidth,
   writeCharRepeated, writeSpaces) used by table.zig and markdown.zig.
   Removed ~170 lines of verbatim duplication. 3 public fns, 4 private helpers.

2. Extract source.zig — Shared openInput() returning SourceFile{file, needs_close}
   with deinit() method. Replaces 9 duplicate file-or-stdin switch blocks
   across columns.zig, sample.zig, and validate.zig.

3. Simplify fmtThousands — Reduced 17-line implementation to 8 lines
   using (digits.len - i) % 3 == 0 instead of first_group calculation.

All tests pass (zig build unit-test + zig build test, exit 0).
Net: +63 lines, -301 lines (-238 net).

Bumps [actions/cache](https://github.com/actions/cache) from 5 to 6.
- [Release notes](https://github.com/actions/cache/releases)
- [Changelog](https://github.com/actions/cache/blob/main/RELEASES.md)
- [Commits](actions/cache@v5...v6)

---
updated-dependencies:
- dependency-name: actions/cache
  dependency-version: '6'
  dependency-type: direct:production
  update-type: version-update:semver-major
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

Add --explain flag that runs EXPLAIN QUERY PLAN on the user's SQL query
and prints the SQLite execution plan to stderr before executing the query.
Each plan line is prefixed with QUERY PLAN: for readability. The actual
query still executes normally with results on stdout.

- Add ExplainWithFlags error, explain field, parsing, and mutual exclusion
  in src/args.zig
- Add printQueryPlan() helper and wiring in src/main.zig
- 11 integration tests in build.zig covering basic usage, stdout cleanliness,
  exit codes, mutual exclusion with all mode flags, nonexistent table error,
  query file support, and empty stdin
- Update README.md and docs/sql-pipe.1.scd with flag documentation

Add -O sql output format that generates INSERT INTO statements per row,
with --sql-table flag for custom table name.

- OutputFormat.sql enum variant in format.zig
- writeSqlRow() with identifier quoting, string literal escaping,
  NULL handling, float truncation (matching JSON pattern)
- --sql-table flag parsing in args.zig (default: "t")
- sql_table wired through execQuery → OutputWriter
- 9 integration tests covering basic, custom table, escaping,
  NULL, numeric, float, empty, quoted columns, quoted table
- README.md and man page updated

Implement a --null-value flag that lets users control how SQL NULL values
are rendered in CSV, TSV, and table output, while preserving native null
in JSON output.

- Parse --null-value in args.zig (--null-value <string>, --null-value=<string>)
- Thread null_value through format.zig, main.zig, table.zig, markdown.zig, xml.zig
- CSV/TSV renders null_value or default "NULL"
- Table output renders null_value or default "NULL"
- Markdown output uses null_value (default empty string)
- JSON always uses native null (flag has no effect)
- 122-line integration tests in build.zig covering CSV default, custom, and empty
- Update help text, README, and man page

Closes #170

…master)

Add html to the output format list. Render SQL query results as an
HTML <table> element with optional <thead> and CSS class support.

- Add html variant to OutputFormat enum
- Implement streaming HTML writer in OutputWriter (begin/writeRow/end)
- HTML-escape all cell values, column names, and class attributes
  via writeXmlEscaped (reused from xml.zig)
- NULL values render as empty cells, custom via --null-value
- --header controls <thead> section
- --html-class <class> sets CSS class on <table>
- Update README.md flags table
- Update docs/sql-pipe.1.scd (options + examples)
- 8 integration tests

Closes #173

)

Generates self-contained shell completion scripts for bash, zsh, and fish.

- New module src/completions.zig with generators for all three shells
- bash: _sql-pipe() function via _init_completion + compgen
- zsh: #compdef script with _arguments specs
- fish: complete -c entries for every flag
- Includes completions for -I/-O format values and --completions shell values
- Integration tests with syntax validation (bash -n, zsh -n, fish --no-execute)

Adds --completions <shell> flag generating bash, zsh, fish completion scripts. Closes #175.

- Add BLOB hex encoding (X'...') in SQL INSERT output instead of
  silent NULL conversion (issue in writeSqlRow else branch)
- Handle zero-length BLOB quirk: check column_bytes() before
  column_blob() pointer (null for empty blobs)
- Integration tests for BLOB round-trip (174j) and empty BLOB (174k)

- Replace 4-range isWideCodepoint() with comprehensive sorted
  [2]u21 range table + binary search (~80 ranges)
- Covers CJK A-H, Hiragana/Katakana, Hangul, Yi, Fullwidth,
  Emoji (terminal convention, noted)
- Fix 3 incorrect expected values in existing visual tests
- Add tests for Hiragana, Katakana, and emoji width

fix: BLOB hex encoding in SQL output + full Unicode width tables