---
id: 20260814-T0-18
title: "sqlite-utils 4.2发布：transform()增强复杂表结构变更"
title_en: "sqlite-utils 4.2 Improves transform(), Enhances Complex Table Alterations"
url: https://ai.daily.yangsir.net/daily/20260814-T0-18
issue_date: 2026-08-14
publish_date: 2026-08-13T20:11:29.000Z
category: release
source_name: "Simon Willison"
source_url: https://simonwillison.net/2026/Aug/13/sqlite-utils/
---

# sqlite-utils 4.2发布：transform()增强复杂表结构变更

sqlite-utils发布4.2版本，重点改进了table.transform()功能。该功能通过创建新表、复制数据、删除旧表并替换的方式实现复杂的ALTER TABLE操作。新版transform()保留了更广泛的表属性，让大规模表结构调整更可靠。开发者可通过pip直接更新。

## English Version

**sqlite-utils 4.2 Improves transform(), Enhances Complex Table Alterations**

sqlite-utils 4.2 ships with significant improvements to table.transform(), which enables complex ALTER TABLE operations by creating a fresh table, copying data, and swapping. The new version preserves a much wider range of table attributes, making large-scale schema changes more robust. Update via pip.

---

**来源**：[Simon Willison](https://simonwillison.net/2026/Aug/13/sqlite-utils/)

**详情页**：https://ai.daily.yangsir.net/daily/20260814-T0-18

---

*智语观潮 · Daily — https://ai.daily.yangsir.net/llms.txt*