v0.9.0: DuckDB-free native Zig SQL engine + multi-platform static binaries
v0.9.0
What's new
- Native Zig SQL parser (M2–M4): full recursive-descent SQL parser pipeline replacing DuckDB at parse time. Zero DuckDB dependency in default build.
- Vendored C sources for cross-compilation (M5): bundled lz4 1.10.0 and zstd 1.5.7 C sources enable static cross-compilation to Linux x86_64 and aarch64 with no external dependencies.
- Multi-platform static binaries: all three release targets are fully statically linked (Linux) or depend only on libSystem (macOS).
count()/count(1)normalization: treated ascount(*)throughout the SQL pipeline.- HAVING clause fix: outer parentheses stripped before predicate matching.
- Generic regression test: new
scripts/generic-regression.sh+ golden output for 1M ClickBench dataset.
Release binaries
| Platform | File |
|---|---|
| Linux x86_64 (musl, static) | zighouse-linux-x86_64 |
| Linux aarch64 (musl, static) | zighouse-linux-aarch64 |
| macOS Apple Silicon | zighouse-macos-aarch64 |
Build flags used
zig build install -Dduckdb=false -Dstatic-libs=true -Dstrip=true -Doptimize=ReleaseFast