Deprecate array any/all implementation specific implementations

[CaselIT]

These method have a peculiar signature that's quite different from the rest of the api.

Since there are alternatives these should be deprecated in 2.1

[zzzeek]

searching around it looks like this starts with:

https://github.com/sqlalchemy/sqlalchemy/blob/a04deb60ac28fa9e2555bb89ffdcd676514ef05d/lib/sqlalchemy/dialects/postgresql/array.py#L50C1-L74C1

and then these two which are marked legacy (so they are already legacy)

https://github.com/sqlalchemy/sqlalchemy/blob/a04deb60ac28fa9e2555bb89ffdcd676514ef05d/lib/sqlalchemy/sql/sqltypes.py#L3119C8-L3215C14

so folks use just any_() and all_() going forward

[sqla-tester]

Mike Bayer has proposed a fix for this issue in the main branch:

deprecate ARRAY.any(), ARRAY.all(), postgresql.Any(), postgresql.All() https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/6155