Release 4.0a1

[simonw]

Lots of interesting changes in this, might be the only alpha we need before a 4.0 stable release.

4.0a0...0bbc680

The big ones:

• db.table() should only return tables, add db.view() #657
• .insert_all() and .upsert_all() to support iterator of Python lists/tuples #672
• Port setup.py to pyproject.toml #675
• Whether or not a table remembers or detects its primary key is confusing and messy #655
• Remove skip_false=True and --no-skip-false in sqlite-utils 4.0 #542
• Use double quotes to escape identifiers instead of square braces #677
• Change default floating point column type from FLOAT to REAL #645
• --functions should take filenames, and be usable multiple times #659
• Make --detect-types the default behavior in 4.0 #679

[simonw]

It's released to PyPI:

uvx --pre sqlite-utils --version

Outputs:

sqlite-utils, version 4.0a1

[simonw]

Changelog: https://sqlite-utils.datasette.io/en/latest/changelog.html#a1-2025-11-23