Button to execute custom SQL

Hi all! I would appreciate if anyone could explain to me how one would go about to:

1. Add a button
2. When button is clicked, some callback kicks in. I. E “Are you sure? Yes/no”
3. If yes, custom SQL is performed on DB (in my case the sql updates a column for all rows in db)

Would be thankful could point me in the right direction!