* Configure foreign key support for Mongo to allow implicit joins

Co-authored-by: metamben <103100869+metamben@users.noreply.github.com>

Fixes #19501

Redshift jdbc driver wraps intervals in a special class whereas postgres
simply returns strings. This unwraps the special redshift class into the
same string representation.

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

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

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

* fix the flaky test for Bigquery

* adds a limit to make sure we don't have a big charge on CI

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

* Snowflake Honey SQL 2

* Test fix 

* Use Honey SQL 2 for GTAP compilation in sandboxing tests

* Test fix 

* Convert sqlite driver to honey-sql-2

* Fix bad case statement

* We can't run native queries with AS for oracle

* Dont call ->honeysql on a honeysql-expr

* Fix bad call to h2x

* Identifier needs to be wrapped

* Update kondo config

* Fix test

* Remove hformat fn handler

* Rotate the Snowflake DB prefix AGAIN

* `sql.qp/format-honeysql` needs to wrap stuff in parens when generating SQL snippets

* Update tests to match new expected SQL format

* Sort namespaces

* Fix the flaky paging test

* Fix flaky `metabase.query-processor-test.timezones-test/filter-datetime-by-date-in-timezone-test`

* MySQL test fix 



* Try running Redshift with a beefier runner

---------

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

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

* Make joins work

* Run fuzzy-field-info-test only against H2

* Set driver/*driver* when performing actions

* Restrict expressions+joins-test to DBs supporting date arithmetics

* Fix ordering of (top level) fields in mongo tables

* Explicitly exclude mongo from tests requiring foreign key support

* Optimize away $sort stage for implicit order-by.

* Robust Snowflake test data loading

* Handle invalid dates

* Removes :presto driver and tests
* Merges :presto-common into :presto-jdbc
* Adds migration to update presto databases to presto-jdbc

---------

Co-authored-by: Cam Saul <github@camsaul.com>

* Updates param parser to ignore SQL comments
* Adds code to disable SQL comment handling in Mongo native query param parsing

* Spark SQL => Honey SQL 2

* Fix stuff 

* Oracle Honey SQL 2

* Remove debugging function

* Fix concat()

* Oracle should use numbers for booleans when loading test data

* Remove driver methods deprecated in 43 and older

* Oops don't delete read-column-thunk

* Update Vertica to implement read-column-thunk instead of read-column

* Remove stray reference to syncable-schemas

---------

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

* Port `:vertica` driver to Honey SQL 2

* Fix 

* One last test fix 

* Support Honey SQL 2 for SQL QP

* Sort namespace

* Make Postgres/Redshift be Honey SQL 2-only

* Test fix 

* Fix busted

* Redshift test fixes 

* Sort namespaces

* Fix Postgres convert_timezone

* Fix linter config.

* Fix one last test failure

* Redshift test fix

* Test fixes and some extra validation etc.

* Update common.clj

* Update common.clj

* Update common.clj

* Enable Kondo `:warn-on-reflection` linter

* Enable warnings for metabase.api.setting-test

* Add warn-on-reflection to metabase.util.jvm

* Adding support for timezone awareness to mongo

* Remove unused ddl multimethod

* Remove mongo from the sql driver type test

* Fix tests and linters

* Add test for filtering datetimes by date in timezone

* Use test-data-with-timezones dataset as it should load in more dbs

* Exclude broken drivers, vertica especially returns no rows

* Address pr review, add timezone to isodate, include a full year of dates in the general timezone test

* Assert against each row

* Presto-jdbc year was not applying timezone

This has the same interface as `clojure.tools.logging` but supports CLJS
as well. It was formerly known as `metabase.shared.util.log`.

Added bans for print and friends. Fixed issues in kondo config where a macroexpansion put in a print by replacing with (constantly nil) as a no-op.

* Switch Audit App to Honey SQL 2

* Compile using Honey SQL 2

* Mark some more tests as ^:parallel

* Remove unused namespace

* Backport sql.qp/current-datetime-honeysql-form :mysql Honey SQL 2 support

* Add `hx/call` and `hx/raw`

* Update enterprise/backend/src/metabase_enterprise/audit_app/pages/common.clj

Co-authored-by: metamben <103100869+metamben@users.noreply.github.com>

* `#schema` => `#hawk/schema`

* Mark `metabase.async.streaming-response-test` as `^:mb/once`

---------

Co-authored-by: metamben <103100869+metamben@users.noreply.github.com>

* Bump athena driver to 2.0.35

* Include aws core for auth

Replaced, as needed, instances of str/lower|upper-case with the -en version. Also updated rules in our kondo config.

Bigquery was checking that we can set a project-id in the db details of
a bigquery database. Normally this comes from the json token:

```
export MB_BIGQUERY_CLOUD_SDK_TEST_SERVICE_ACCOUNT_JSON='{
  "type": "service_account",
  "project_id": "metabase-bigquery-driver", // <- ordinarily source of truth
  "private_key_id": "keykeykeykeykeykeykeykey",
  "private_key": "-----BEGIN PRIVATE KEY----- ...."
```

The db details normally connects to project-id
"metabase-bigquery-driver" and this test swaps out to
"bigquery-public-data" with a schema filter on chicago_taxi_trips.

to prove it works it selects from that dataset:

```
(mt/first-row
  (mt/run-mbql-query taxi_trips
    {:filter [:= [:field (mt/id :taxi_trips :unique_key) nil]
                 "67794e631648a002f88d4b7f3ab0bcb6a9ed306a"]}))
```

The test fails because this row seems to no longer be in the
results. The query isn't failing, it's just returning no rows (and
presumably because the row with this id from 2014 is no longer in the
dataset.)

I ran the same with with a limit 4, see it's working and grab one of
those rows and use the id as in the filter clause.

old: "67794e631648a002f88d4b7f3ab0bcb6a9ed306a" ("2014-01-12T00:45:00Z")
new: "ff0b96c0cada768361b1c9341e11905254644afb" ("2016-09-20T07:15:00Z")

* Simplify the calculation of mongo column types

* Remove TODO, since driver.common/class->base-type is being used

We can now filter out any ns tag for tests.

Use the vertica/vertica-ce:12.0.2-0 image.

Also point out that PKCS12 (.p12) keystores are now supported.

* move malli schema from metabase.util.schema to a new ns metabase.util.malli.schema

* revert name changes for plumatic schema. e.g: NonBlankStringPlumatic -> NonBlankString

* add clj-kondo rule to enforce consistent alias for metabase.util.malli.schema