(7.4.z) org.hibernate.testing.junit4.BaseCoreFunctionalTestCase#cleanupTestData fails on PostgreSQL Plus 13.1 with PSQLException

This is a clone of https://hibernate.atlassian.net/browse/HHH-14675

Executing the SQL expression:

Hibernate: delete from ALL_TABLES.

results in PSQLException which is thrown in the org.hibernate.testing.junit4.BaseCoreFunctionalTestCase#cleanupTestData method after each org.hibernate.test.annotations.query.QueryAndSQLTest test is completed:

Caused by: com.edb.util.PSQLException: ERROR: cannot delete from view "all_tables"
  Detail: Views containing WITH are not automatically updatable.
  Hint: To enable deleting from the view, provide an INSTEAD OF DELETE trigger or an unconditional ON DELETE DO INSTEAD rule.

Perhaps, the SQL expression that creates all_tables view could be slightly reworked/updated.

Environment:

oracle-java-1.8
postgresplus 13.1
hibernate.dialect org.hibernate.dialect.PostgresPlusDialect
EnterpriseDB JDBC Driver 42.2.12.3