*** DRAFT ***

SQLite Release 3.52.0 On 2026-03-01

  1. Enhance ALTER TABLE to permit adding and removing NOT NULL and CHECK constraints.
  2. Add the SQLITE_PREPARE_FROM_DDL option to sqlite3_prepare_v3() which permits virtual table implementations to safely prepare SQL statements that are derived from the database schema.
  3. Add the Query Result Formatter (QRF) library for formatting the results of SQL queries for human readability on a fixed-pitch font screen.
    1. Add the format method to the TCL Interface so that QRF is accessible from TCL.
    2. QRF is used for result formatting in the CLI, resulting in improved display capabilities.
  4. Renovations to the CLI:
    1. Major enhancements to the .mode command.
    2. The default output mode for interactive CLI sessions now uses QRF to display query results in boxes formed using Unicode box-drawing characters, for improved legibility. Batch CLI sessions use the legacy output format for compatibility.
    3. Bare (unquoted) semicolons at the end of dot-commands are silently ignored.  ← Potentially incompatiblity!
    4. Fix the .testcase and .check commands so that they actually work, and use those commands in scripts that part of the standard SQLite test suite included with the source tree.
    5. Command-line arguments that match *.sql or *.txt and that are the names non-empty files are read and interpreted as scripts of SQL statements and/or dot-commands.
    6. QRF is used for result formatting, resulting it improved output formatting. Example: numeric values are now right-justified by default in tabular output modes.
  5. New C-language interfaces:
    1. sqlite3_str_truncate()
    2. sqlite3_str_free()
    3. SQLITE_LIMIT_PARSER_DEPTH

    Hashes:

  6. SQLITE_SOURCE_ID: pending
  7. SHA3-256 for sqlite3.c: pending

A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site.

*** DRAFT ***