Ultorg has a bundled internal PostgreSQL database that is used for query execution over Excel/GSheets/CSV/MS Access sources. The tables are automatically dumped

Ultorg has a bundled internal PostgreSQL database that is used for query execution over Excel/GSheets/CSV/MS Access sources. The tables are automatically dumped into PostgreSQL in an efficient manner when necessary. If you hit the Refresh button in the toolbar (F5 or Ctrl+R), Ultorg checks if there are changes in the original sources and refreshes the extracts if necessary. The same mechanism kicks in if you join tables from different data sources in a single visual query. E.g. you might join a table in a remote PostgreSQL database with a table in a local CSV file. Both tables end up getting extracted locally. There's a "Generated Extracts" folder in the sidebar where you can see a list of table extracts that were auto-generated on the local machine. The process is otherwise seamless, and queries in fact often perform much better locally than being executed on a remote database. The latter is due to no network latency, powerful laptops, and a custom PostgreSQL configuration on the local database that is tuned for single-user ad hoc queries.