Description
Add sql to the output format list. Generate SQL INSERT statements from query results.
sql-pipe data.csv -O sql 'SELECT * FROM t WHERE active = 1'
# INSERT INTO t (id, name, active) VALUES (1, 'Alice', 1);
# INSERT INTO t (id, name, active) VALUES (3, 'Carol', 1);
Motivation
Useful for data migration between databases, seeding databases, and creating test fixtures. Currently users must convert query output to INSERT statements manually.
Acceptance Criteria
Implementation Notes
- Similar to other output formatters in
format.zig
- Use
writeJsonString-style escaping for SQL string values (adapt for single quotes)
- About 40-50 lines of new code
Description
Add
sqlto the output format list. Generate SQL INSERT statements from query results.Motivation
Useful for data migration between databases, seeding databases, and creating test fixtures. Currently users must convert query output to INSERT statements manually.
Acceptance Criteria
sqlto theOutputFormatenum insrc/format.zigINSERT INTO <table> (<cols>) VALUES (<vals>);for each row--sql-table <name>flag to specify target table name (default: "t")NULL(no quotes)Implementation Notes
format.zigwriteJsonString-style escaping for SQL string values (adapt for single quotes)