[Manual backport 49] Fix sync indexes mark all fields with same name as indexed if one of them is (#46316)

* Fix sync indexes mark all fields with same name as indexed if one of them is (#46313)

* not the lib.match

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

Co-authored-by: Cal Herries <39073188+calherries@users.noreply.github.com>

This PR removes `:role` removal from spec, even if it was added in `:connection-uri`.
It seems that `:connection-uri` is ignored on `do-with-connection-options` code path.
Hence use of non-default roles is again available on Snowflake.

[backport for 49] Fix fields from Amazon Athena Tables failing to sync if there is not an underscore in the Table Name (#44032) (#44245)

* Add connection string parsing

* Add test case with role suffixed key

Co-authored-by: lbrdnk <lbrdnk@users.noreply.github.com>

* Move role to url parameters from connection properties

* Fix test

Co-authored-by: lbrdnk <lbrdnk@users.noreply.github.com>

Co-authored-by: Mahatthana (Kelvin) Nomsawadi <me@bboykelvin.dev>

Co-authored-by: Ngoc Khuat <qn.khuat@gmail.com>

Co-authored-by: Ngoc Khuat <qn.khuat@gmail.com>

Co-authored-by: Ngoc Khuat <qn.khuat@gmail.com>

 backported "Redshift and Oracle test sync: do not use hack" and "Faster driver/describe-database for redshift" (#42109)

* ~ fix merge conflicts

* backported "Faster driver/describe-database for redshift" (#42112)

---------

Co-authored-by: Cal Herries <calherries@gmail.com>
Co-authored-by: Cal Herries <39073188+calherries@users.noreply.github.com>

* Comment out failing snowflake test sync-dynamic-tables-test

* unrelated indent

Co-authored-by: Ngoc Khuat <qn.khuat@gmail.com>

 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>

I need to test a bugfix with a customer (Fixed an issue with parsing large responses (greater than 16MB)) in 49.7

Co-authored-by: Luis Paolini <paoliniluis@gmail.com>

* Update resolve-private-key and add test

Co-authored-by: lbrdnk <lbrdnk@users.noreply.github.com>

Co-authored-by: lbrdnk <lbrdnk@users.noreply.github.com>

* Use dbname from details instead of from stats

* Add mongo sharded cluster CI job

Co-authored-by: lbrdnk <lbrdnk@users.noreply.github.com>

Co-authored-by: Cal Herries <39073188+calherries@users.noreply.github.com>

* Enable not emptyable arguments for is-empty and not-empty clauses (#40957)

* Enable not emptyable arguments for is-empty and not-empty clauses

* Add review remarks

* Shorten dataset name so it is usable with some drivers

* Disable test for Athena

* Handle possibly missing base type

* Update comment

* Missing base type field is treated as not emptyable

* Update desugar middleware

Now middleware adds base type to fields with integer id that are missing that first. This ensures correct function of is-empty expansion.

* Update desugar middleware

Cleanup base types necessary for desugaring is-empty

* Update desugar middleware cleanup

* Update test

* Adjust tests

* Remove now redundant e2e test

* Update comment

* Backport new emptyable definition and derivates

---------

Co-authored-by: lbrdnk <lbrdnk@users.noreply.github.com>

* Add backport resolution script

* backport #40767 to 49

---------

Co-authored-by: Metabase bot <metabase-bot@metabase.com>
Co-authored-by: Ngoc Khuat <qn.khuat@gmail.com>

* Fix duplicate native column nesting

* Try wrapping source-query in WITH statement

* Fix tests

* Fix tests

* Only wrap in with when needed

* More fixes

* Update names and comments

* Address PR review

Co-authored-by: Case Nelson <case@metabase.com>

* Add backport resolution script

* Fix filtering on LocalDates (#40530)

* Split from #40146: only the filter changes

* Don't include format-rows changes here.

* Test fixes 

* Test fix 

* Misc test fixes 

* Test fix 

* Tweak SQL Server fix

* Fix Kondo errors

* Updated api/dataset tests

* Test fix 



---------

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

* Redshfit: sync tables with partial select permission (#40421)

* uncomment since 40058 is backported

---------

Co-authored-by: Ngoc Khuat <qn.khuat@gmail.com>

Co-authored-by: Callum Herries <calherries@gmail.com>

* Add alternative hostname support to snowflake

* move hostname support out of additional details

* Update modules/drivers/snowflake/src/metabase/driver/snowflake.clj



* Update modules/drivers/snowflake/src/metabase/driver/snowflake.clj



* Update modules/drivers/snowflake/test/metabase/driver/snowflake_test.clj



* opt-in

---------

Co-authored-by: Cal Herries <39073188+calherries@users.noreply.github.com>

Co-authored-by: Cal Herries <39073188+calherries@users.noreply.github.com>
Co-authored-by: Chris Truter <crisptrutski@users.noreply.github.com>

* Faster sync-fks (#38970)

* Change driver changelog and remove describe-table-fks in 52 instead of 53

---------

Co-authored-by: Cal Herries <39073188+calherries@users.noreply.github.com>
Co-authored-by: Callum Herries <calherries@gmail.com>

Co-authored-by: Ngoc Khuat <qn.khuat@gmail.com>

Co-authored-by: Ngoc Khuat <qn.khuat@gmail.com>

Co-authored-by: Cal Herries <39073188+calherries@users.noreply.github.com>

When determining column aliases in `add-alias-info`, reuse an existing
desired column alias if one is present.

Fixes #39059. Might fix #25931.

Co-authored-by: Braden Shepherdson <braden@metabase.com>

* Fix mongo password handling

* Update test, add credential check

* Address the review remarks

Co-authored-by: lbrdnk <lbrdnk@users.noreply.github.com>

Co-authored-by: Cal Herries <39073188+calherries@users.noreply.github.com>

* Fix snowflake ssh tunnel

* Put test where it will run in CI

* Override incorporate-ssh-tunnel

* Revert snowflake in util.ssh-test

* Move tunnel connection tests to sql_jdbc

* Add mock-server fixture

* Exclude drivers from tunnel test

* Fix up reconnection tests

* Exclude more drivers

* Address PR feedback

Co-authored-by: Case Nelson <case@metabase.com>