sections_fts: 51
This data as json
| rowid | title | content |
|---|---|---|
| 51 | Write SQL UI | New "Write to this database" interface at /<database>/-/execute-write for running arbitrary writable SQL against mutable databases. The form extracts named parameters, analyzes the SQL, shows the table operations that will be attempted, includes starter templates for INSERT , UPDATE and DELETE statements and links to a newly inserted row when a single-row insert succeeds. This is also available as a JSON API . ( #2742 ) Added the new execute-write-sql permission for running arbitrary writable SQL. Execution is also gated by table-level permissions such as insert-row , update-row and delete-row , and writes to attached databases are rejected. ( #2742 ) The write SQL analyzer now uses a deny-by-default model for unsupported operations. Reads from source tables require view-table permission, schema changes require create-table , alter-table or drop-table as appropriate, and row mutation statements require the full insert-row , update-row and delete-row permission set. SQL functions are allowed and are not separately permission-gated. ( #2748 ) User-supplied write SQL rejects both VACUUM operations and writes to SQLite virtual or shadow tables. These restrictions also apply to untrusted stored write queries; trusted queries in datasette.yml skip these filters. ( #2748 ) |