SQLite Query Result Formatter Demo

Simon Willison's Blog Tools
sqlite query-formatter webassembly demo interactive-tool sql

Summary

Interactive WebAssembly-based demo for SQLite Query Result Formatter that allows users to format SQL query results in 20+ styles including tables, CSV, JSON, HTML, and Markdown with real-time adjustments.

No content available
Original Article
View Cached Full Text

Cached at: 04/20/26, 08:28 AM

# Tool: SQLite Query Result Formatter Demo Source: https://simonwillison.net/2026/Apr/11/sqlite-qrf/ Tool: SQLite Query Result Formatter Demo (https://tools.simonwillison.net/sqlite-qrf) — Format SQLite query results in 20 different styles including box-drawing tables, CSV, JSON, HTML, Markdown, and more using this interactive WebAssembly-based demonstration. Adjust formatting options like column headers, screen width, NULL display values, and border styles in real-time to see how your SQL queries render across all available output modes. The demo database includes sample tables for employees, products, and orders with pre-built example queries showcasing each formatting style. See my notes on SQLite 3.53.0 (https://simonwillison.net/2026/Apr/11/sqlite/). This playground provides a UI for trying out the various rendering options for SQL result tables from the new Query Result Formatter library, compiled to WebAssembly.

Similar Articles

SQLite Query Explainer

Simon Willison's Blog

A browser-based tool that runs SQL queries against SQLite and provides plain-English explanations of the query plan and bytecode output.

Show HN: Graphical SQL Builder and Debugger

Hacker News Top

SQL Joiner is a visual SQL query builder for MySQL that lets you build SELECT queries by dragging tables onto a canvas, with support for joins, subqueries, and importing existing SQL.

SQLite 3.53.0

Simon Willison's Blog

SQLite 3.53.0 releases with significant accumulated improvements including ALTER TABLE constraint modifications, new JSON functions (json_array_insert), and major CLI mode enhancements via a new Query Results Formatter library.

datasette 1.0a31

Simon Willison's Blog

Datasette 1.0a31 introduces the ability to execute write queries and save stored queries (renamed from canned queries) for users with appropriate permissions, enhancing data editing capabilities.