I am using liquibase with spring-boot. My requirement is that before i run and INSERT/UPDATE/DELETE I want to know which records will be updated. Is there a way to run a SELECT query which output the results then run the DML query?
I have tried using the RETURNING attribute in POSTGRES but it didn't return the records which gets affected.