sections: sql_queries:id3
This data as json
| id | page | ref | title | content | breadcrumbs | references |
|---|---|---|---|---|---|---|
| sql_queries:id3 | sql_queries | id3 | Trusted stored queries | A trusted stored query can execute with view-query permission alone. It skips the additional execute-sql and write permission checks that are applied to untrusted stored queries. Trusted stored queries should only be used for SQL that has been reviewed by someone trusted to configure the Datasette instance. For that reason, trusted stored queries can only be added using configuration. Users cannot create trusted stored queries through the web interface or the stored query JSON API. Queries defined in datasette.yaml are trusted by default: databases: mydatabase: queries: report: sql: select * from report You can opt out of this behavior for a configured query using is_trusted: false : databases: mydatabase: queries: report: sql: select * from report is_trusted: false | ["Running SQL queries", "Queries", "Stored queries"] | [] |