SQLBlitz

From the App Store Source

SQLBlitz lets you query CSV, Parquet, and JSON files with SQL - directly, instantly, no setup required. No database to configure. No import process. No waiting. Just open your file and start writing SQL. It's the tool that should have existed years ago. QUERY FILES DIRECTLY WITH SQL Other tools make you import data into a database first. SQLBlitz opens your files and lets you query immediately. CSV, Parquet, JSON - just import in milliseconds and SELECT. HANDLES FILES THAT CRASH OTHER APPS Built on DuckDB's analytical engine. Load a 500MB CSV with 2 million rows in 1.2 seconds. Get query results in 20 milliseconds. Open files that make Numbers and Excel give up. NATIVE MAC APP Not Electron. Not Java. A real macOS app that's fast, light, and feels like it belongs on your Mac. POWERFUL QUERY EDITOR - Syntax highlighting with dozens of themes - Tabbed query windows that persist across sessions - Run queries with ⌘+Enter - Save queries as .sql files - Query history with one-click recall - Click column names in schema browser to insert them SMART DATA MANAGEMENT - Data sources persist across sessions - reload only what you need - Name tables on import - Unload files to free memory - Live memory usage display FAST RESULTS - Paginated results handle millions of rows - Copy all to clipboard - Export to CSV 100% PRIVATE All processing happens locally. No data collection. No telemetry. No network access. Your data stays on your Mac. Stop importing. Start querying.

Every number in these answers comes from the data shown above on this page.