CSV SQL

Take a CSV file, query it with SQL. Magic!

.. code-block:: console

$ cargo run file.csv
Loaded 3162 rows into t(domain, base_domain, agency, sslv2)
> SELECT COUNT(*) FROM t
+----------+
| 3162     |
+----------+

All your rows go into a table named

t

You can also specify multiple files:

.. code-block:: console

$ cargo run file1.csv file2.csv
Loaded 12 rows into t1(some, schema)
Loaded 74 rows into t2(some, other, schema)
>

If you'd like to export the results of a query to a CSV file:

.. code-block:: console

$ cargo run file.csv
Loaded 3162 rows into t(domain, base_domain, agency, sslv2)
> .export(results.csv) SELECT COUNT(*) from t;

If you have tab-, pipe-, or semicolon-delimited files you can specify

--tab

--pipe

--semicolon

UDFs

csv-sql

regexp_extract(pattern, value, replacement)

Example:

regexp_extract("abc-(\d+)", "abc-12345", "lol $1")

"lol 12345"

Binaries

Binaries for macOS and Windows are automatically built in CI and can be downloaded from Github Actions.