Ad2: Every single real world java project I have seen used hibernate (ORM) with flyway. I never ever seen any project in production where some underlying tech would be deleting tables autonomously.
Ad1: People do debug ORMs, actually. Including queries effectivity.