backported "Fix Snowflake/Redshift filtering on date for timestamp with time zone columns" (#42088)

* Fix Snowflake/Redshift filtering on date for timestamp with time zone columns (#41864)

* Fix Snowflake filtering on date for `timestamp with time zone` columns

* Snowflake should just generate raw SQL for literals

* Go ahead and fix other Snowflake stuff and reenable a bunch of disabled tests

* Snowflake test fixes 



* Minor test improvements

* Fix Redshift and Vertica as well.

* Address PR feedback

* Remove test for fix that isn't part of this PR

* Remove stuff only in >= 50

* Backport change to skip feature validity check for namespaced driver features

---------

Co-authored-by: Cam Saul <1455846+camsaul@users.noreply.github.com>
Co-authored-by: Cam Saul <github@camsaul.com>