So what do you think about it? Do you think is it useful?
The cost/benefit ratio seems low...
Also, when recovering with the current specification, tables other than the returned table also return to the state of the specified recovery point. So, I’m looking for ways to recover only specific tables. Do you have any ideas?
...and this lowers it even further.
I'd rather spend effort making the initial execution of said commands less likely. Something like:
TRUNCATE table YES_I_REALLY_WANT_TO_DO_THIS;
which will fail if you don't add the keyword "YES_I..." to the end of the command and the system was setup to require it.
Or, less annoyingly:
BEGIN;
SET LOCAL perform_dangerous_action = true; --can we require local?