I asked for the "default" . The default setting for run behavior. With the way you tell; you need to always select the run behavior and it is open for mistakes.
The default run behavior for SQL mode queries and get requests (read queries) is Automatic. If you switch the query to a delete action, post request, or GUI mode for SQL (write queries), the run behavior will be switched to Manual. The default for Javascript and AI queries is manual.
The feature request linked previously is in our backlog still, so I don't have a timeline for a fix I'll add your +1 though