vmvarela is a solo developer whose public footprint revolves around minimalist, command-line data utilities built for speed and transparency. The flagship offering, sql-pipe, distills the publisher’s philosophy into a single self-contained executable: it listens to standard input for any CSV stream, lets analysts run ad-hoc SQL (SQLite dialect) against the data as if it were a real database table, then emits the result back to standard output as clean CSV. This design turns everyday shell scripts into ad-hoc ETL pipelines—no heavyweight BI stack, no Excel gymnastics, no intermediate files. Typical use cases include on-the-fly filtering of multi-gigabyte log exports, quick joins between independently exported reports, reformatting messy survey dumps before ingestion into R or Python notebooks, or even sanitizing data while it is still being streamed from a remote endpoint. Because the tool respects Unix conventions, it slots naturally into PowerShell, bash, or batch chains alongside classics like grep, sed, awk, jq, or psql, so Windows data wranglers can enjoy the same pipe-friendly ergonomics long cherished on *nix systems. vmvarela keeps the source open on GitHub, publishes signed Windows builds, and refreshes binaries whenever SQLite itself is updated. sql-pipe and any future utilities from vmvarela are available for free on get.nero.com, where downloads are delivered through trusted Windows package sources such as winget, always install the latest version, and can be queued for batch installation alongside other applications.
Read CSV from stdin, query with SQL, write CSV to stdout
Details