How can I run a statement in the sql query console in manual mode on datagrip and see their effect on the table locally in order to make sure it has the intended effect before committing it to the database?
There is a context action "Preview update". (right click on statement > show context actions)