Description
Allow loading SQLite extensions to extend SQL functionality (e.g., spellfix, percentile, custom functions).
Examples
sql-pipe --extension /path/to/spellfix.so data.csv \
'SELECT * FROM t WHERE name MATCH "alice"'
Acceptance Criteria
Notes
- Implementation: ~30 lines
- Use
sqlite3_load_extension() C API
- Power-user escape hatch that adds zero complexity to common case
- Low priority but unlocks niche use cases without bloating binary
Description
Allow loading SQLite extensions to extend SQL functionality (e.g.,
spellfix,percentile, custom functions).Examples
sql-pipe --extension /path/to/spellfix.so data.csv \ 'SELECT * FROM t WHERE name MATCH "alice"'Acceptance Criteria
--extension <path>flag loads SQLite extensionNotes
sqlite3_load_extension()C API