Analytical SQL queries on Postgres will run in a fraction of the time compared to standard editors. A query that originally took me 40+ minutes ran in just 14.6 seconds with soarSQL.
By leveraging duckDB's processing engine, your queries will perform like those on an OLAP system such as BigQuery, Redshift, or Snowflake. You won't need to materialize a copy of your data or perform extra processing.
Since soarSQL handles the bulk of the processing locally on your device, you will save money and minimize the risk of overloading your database.
