sections: changelog:alter-table-support-for-create-insert-upsert-and-update

This data as json

id	page	ref	title	content	breadcrumbs	references
changelog:alter-table-support-for-create-insert-upsert-and-update	changelog	alter-table-support-for-create-insert-upsert-and-update	Alter table support for create, insert, upsert and update	The JSON write API can now be used to apply simple alter table schema changes, provided the acting actor has the new alter-table permission. ( #2101 ) The only alter operation supported so far is adding new columns to an existing table. The /db/-/create API now adds new columns during large operations to create a table based on incoming example "rows" , in the case where one of the later rows includes columns that were not present in the earlier batches. This requires the create-table but not the alter-table permission. When /db/-/create is called with rows in a situation where the table may have been already created, an "alter": true key can be included to indicate that any missing columns from the new rows should be added to the table. This requires the alter-table permission. /db/table/-/insert and /db/table/-/upsert and /db/table/row-pks/-/update all now also accept "alter": true , depending on the alter-table permission. Operations that alter a table now fire the new alter-table event .	["Changelog", "1.0a9 (2024-02-16)"]	[{"href": "https://github.com/simonw/datasette/issues/2101", "label": "#2101"}]