Delete all records SQL statement

Over the years I’ve had many cases where there was a need to clean up 1M+ records from the database. Usually this is caused by forgetting to clean up data regularly but nevertheless it happens very often.

All current best-practice solutions are not working to my satisfaction:

• Delete in batches / background / task queue and then using the standard delete-action will not cause any memory issues but still takes hours to delete all records.
• OQL-statements are read only so no deletes possible
• Community commons ‘DeleteAll’ cannot handle large amounts of records at all
• SQL-statements in the database connector can only be used on external DB’s

So it would be really nice to be able to perform a direct SQL-delete-query on the internal database in order to delete millions of records in a matter of seconds instead of hours.