Anyquery is a SQL query engine that enables you to execute SQL queries on virtually anything, including Parquet files. Under the hood, Anyquery uses SQLite as the storage engine, which allows you to import Parquet files into SQLite with a straightforward SQL query.
anyquery -q "CREATE TABLE parquet AS SELECT * FROM read_parquet('path/to/file.parquet')"
Additionally, you can modify each column using functions such as upper
. For example, the following query imports a Parquet file into SQLite and converts the name
column to uppercase:
anyquery -q "CREATE TABLE parquet AS SELECT upper(name), age FROM read_parquet('path/to/file.parquet')"
See the functions documentation for more information on the available functions.