Unable to drop view with default server configuration

[dimas-b]

Describe the bug

Run Polaris from recent main with all config defaults.

In Spark SQL do:

spark-sql (default)> use polaris;
spark-sql ()> create namespace ns;
spark-sql ()> create view ns.v1 as select 'abc';

spark-sql ()> drop view ns.v1;
25/08/15 13:18:09 ERROR SparkSQLDriver: Failed in [drop view ns.v1]
org.apache.iceberg.exceptions.ForbiddenException: Forbidden: Unable to purge entity: v1. To enable this feature, set the Polaris configuration DROP_WITH_PURGE_ENABLED or the catalog configuration polaris.config.drop-with-purge.enabled

Note that the client-side SQL does not request "PURGE".

To Reproduce

No response

Actual Behavior

No response

Expected Behavior

No response

Additional context

No response

System information

No response

[dimas-b]

This is apparently a side effect of #1619.

Given that #1617 provides sound reasons for disabling DROP with PURGE by default, I believe users need a way to perform DROP VIEW without PURGE (which is possible for tables).