SQL2ALL is a simple tool that allows you to asynchronically store your SQL queries in any format you like and then run them against any database you like. It is designed to be simple to use and easy to extend.
Support for the following databases is included:
- MySQL/MariaDB (mysql_async)
- PostgreSQL (tokio-postgres)
- SQLite (rusqlite)
- Graph Database (Neo4j/KuzuDB)
Support for the following output formats is included:
- CSV
- JSON
- Parquet
- ORC
- Avro
- Lance
sql2all -u <url> -o <output> -q <query>
sql2all -u "mysql://root@localhost:3306/test" -o "test.parquet" -q "select * from payment"
sql2all -u "postgresql://root@localhost:5432/test" -o "test.csv" -q "select * from payment"
sql2all -u "sqlite:///test.db" -o "test.json" -q "select * from payment"