on_success_message_sql option for writable canned queries

[simonw]

Or... how about if the on_success_message option could define a SQL query to be executed to generate that message? Maybe on_success_message_sql.

• Add writable canned query demo to latest.datasette.io #2134

[simonw]

Goal here is to customize the message displayed after a query has succeeded. e.g.

databases:
  mydatabase:
    queries:
      add_name:
        sql: INSERT INTO names (name) VALUES (:name)
        write: true
        on_success_message_sql: 'select ''Name inserted: '' || :name'
        on_success_redirect: /mydatabase/names

[simonw]

Here's what it looks like when it works:

And here's what you get if there's a SQL error in the on_success_message_sql query itself: