Open a SQLite database as a table
A .sqlite or .db file opens on its first table; the others are named in the status
bar. Look through it, filter it, query it, and export it to CSV, Excel or Parquet. Saving writes a database holding
the table you are editing — so for a database with several tables, use Save As and keep the original.
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.
