Open a SQLite database as a table
A .sqlite or .db file opens the table you pick — its tables are its sheets, views
among them, in the order they were made. Look through it, filter it, query it, and export it to CSV, Excel or
Parquet.
A database holds more than the table on show, so saving never writes over it: ⌘S asks where a copy goes, and the database you opened stays exactly as it was, every other table included.
SQL over everything, not just databases
The query console treats every open document as a table: a CSV, a workbook and a SQLite file can be joined in one
statement. The dialect is MySQL-flavoured on top of SQLite — backticks, GROUP_CONCAT,
DATE_FORMAT, REGEXP — and a MySQL dump can be pasted in as it stands.
How to query CSV files with SQL.
Export to a database
Any table exports as a real SQLite database file with one table, or as SQL inserts for a table you
name — with or without CREATE TABLE, and with as many rows per INSERT as the server
likes.
