DuckDB is a newer datastore built especially for OLAP. It's about as easy to use as SQLite, and has improved support for built-in data types. It can run in-memory (just while scripts are running), and ...

See Example SQL Script from CLI-Directory/sql_scripts. You can create your own SQL file from sql_scripts Directory. You can also create or rename extract.bat file ...