* Snowflake Honey SQL 2

* Test fix 

* Use Honey SQL 2 for GTAP compilation in sandboxing tests

* Test fix 

* Fix linter

* Make sure we're inlining num in substitution and sum aggregations

* Set hsql version

* Fixing tests

* Fixing tests after the h2 conversion

* Use h2x/extract in h2, fix test differences

* Fixing tests for honeysql2

* Only numbers get inlined

* More test fixes

* Fixing tests

* Undo bad commit

* Inline Ratio must produce doubles or h2 will do integer division where 1/2 = 0

* Fix bad case statement

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

---------

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

* 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>

Originally made all "drivers" tests skip the :mb/once test selected test
namespaces. But we use the drivers matrix to test the different app-db
types (mysql, postgres). So this moves the `:exclude-tags [:mb/once]`
selector off of the drivers job and into particular driver jobs.

```clojure
user=> (letfn [(uses-exclude? [[job-name job]]
                 (let [steps (:steps job)]
                   (reduce (fn [uses? step]
                             (if-let [with (:with step)]
                               (if (= ":exclude-tags '[:mb/once]'" (:test-args with))
                                 (reduced true)
                                 uses?)
                               uses?))
                           false
                           steps)))]
         (-> (group-by uses-exclude? (:jobs (yaml/from-file ".github/workflows/drivers.yml")))
             (update-vals (fn [jobs] (map key jobs)))))
{true (:be-tests-athena-ee
       :be-tests-bigquery-cloud-sdk-ee
       :be-tests-druid-ee
       :be-tests-googleanalytics-ee
       :be-tests-mongo-4-2-ee
       :be-tests-mongo-4-2-ssl-ee
       :be-tests-mongo-5-0-ee
       :be-tests-mongo-5-0-ssl-ee
       :be-tests-mongo-latest-ee
       :be-tests-oracle-18-4-ee
       :be-tests-oracle-21-3-ee
       :be-tests-presto-186-ee
       :be-tests-presto-jdbc-ee
       :be-tests-redshift-ee
       :be-tests-snowflake-ee
       :be-tests-sparksql-ee
       :be-tests-sqlite-ee
       :be-tests-sqlserver-ee
       :be-tests-vertica-ee),
 false (:be-tests-google-related-classpath-ee ;; includes an :only selector
        :be-tests-mariadb-10-2-ee
        :be-tests-mariadb-latest-ee
        :be-tests-mysql-5-7-ee
        :be-tests-mysql-latest-ee
        :be-tests-postgres-ee
        :be-tests-postgres-latest-ee)}
```

These maria/mysql/postgres tests all specify `MB_DB_TYPE` so we omit the
`exclude-tags` selector to run all tests. The only strange one here is
the `:be-tests-google-related-classpath-ee` job which includes an :only
selector:

```yaml
    steps:
    - uses: actions/checkout@v3
    - name: Test Google Related Classpath drivers
      uses: ./.github/actions/test-driver
      with:
        junit-name: 'be-tests-${{ matrix.driver }}-classpath-ee'
        test-args: ':only "[metabase.query-processor-test.expressions-test metabase.driver.google-test metabase.driver.googleanalytics-test]"'
```

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

* Fix mongo version checking for now

* Add minor versions for comparison

* Handle nil case

* newline

* Replace _

* Use dbms-version semantic-version instead

* Compare only the major and minor version

* Fix mongo database-supports?

* Fix duplicate require

* Fix typo

* Remove expressions from version check

* Fix various mongo expressions

`trim`, `rtrim`, `ltrim` needed to be wrapped in `{"input" expr}` object
`replace` needed to be wrapped in `{"input" expr "find" ...
"replacement" ...}' object
`substring` needed to fill in the 3rd argument, optional in mbql but
required in mongo. Also to use a 1 based index

* Generalize semantic-version-gte

* Used synced dbms_version for testing feature support

* Expressions are only supported by mongo 4.2+

* Disable some tests

* Fix mongo division

Handle nulls with an upfront condition check.
Handle multiple divisors.

* Remove unused namespace

* Throw exeception if using replace on mongo < 4.4

* Skip test because of #27249

* Move minimum Mongo CI version to 4.2

* Fix sorting by expressions

$sort needs to come before $project otherwise we can only see the
projected fields, however expressions are only added in $project.

So now if a sort includes an expression, we will use $addFields to be
able to sort by that expression.

* Disable tests for expressions inside aggregations

To be addressed by #27275

* Handle aggregation nested in an expression

* Remove :truncation-start workaround

* Enable tests for expressions inside aggregations

* Fix datetime-math-tests

* Make sure dbms_version is included when fetching database for store

* Update doc for replace to indicate it should replace all occurrences

* Fix order-by-test

* Handle embedded special aggregations (#27315)

* Handle embedded special aggregations
* Preserve aggregation options for nested aggregations
* Use top-level aggregation name as group name

* Disable nil punning on semantic version check (#27317)

* Optimize produced query for division when dividing by literals

* Rename var

* Use reduce to build division

* Fix reduction

* Clean up formatting and document some details

Co-authored-by: Callum Herries <hi@callumherries.com>
Co-authored-by: Tamás Benkő <tamas@metabase.com>
Co-authored-by: metamben <103100869+metamben@users.noreply.github.com>

This reverts commit a63f9bd1.

* Use gvenzl/oracle-xe docker to test Oracle
* Configure SSL connection for Oracle 21.3
* Fix secret handling

* Migrate Oracle driver test to GitHub Actions

* Provide Oracle server details

* Add "Hello, World!" CircleCI config

* Migrate Mongo 5 ssl driver test to GitHub Actions

* Migrate Mongo 4 ssl driver test to GitHub Actions

* Make Mongo certificates available

* Try `docker exec` for Mongo 4.0

* Remove `TTY` from the `exec`

* Try overriding the entrypoint

* Include `mongod` in entrypoint

* Quote entrypoint command

* Quote only the command

* Omit `--dbpath`

* Try running the docker container manually

* Detach containers

* Reduce the timeout

* Remove Presto 186 config

We've already migrated it to GitHub actions.

* Migrate Presto JDBC driver test to GitHub Actions

* Wait for port to be ready

* Try `presto-jdbc` driver

* Wait for port before creating certificates

* Migrate BigQuery SDK driver test to GitHub Actions

* Migrate Google related classpath drivers test to GitHub Actions

* Multi-line strings are not working?

* Provide BQ envs

* Migrate Snowflake driver test to GitHub Actions

* Do not run test when PR is in a draft mode

* Dial down timeout to 60 minutes

* Migrate Google Analytics driver test to GitHub Actions

* Migrate Redshift driver test to GitHub Actions

* Migrate Athena driver test to GitHub Actions

* Migrate vertica driver test to GitHub Actions

* Bump runner for vertica

* Do not use matrix as it messes the output

* Add vertica port to the image config

* Go back to the official GitHub runner

* Do not run driver tests when PR is in a draft mode

* Use the conditional directly on the job level

* Migrate MySQL latest driver test to GitHub Actions

* Increase the timeout for MySQL latest driver test

* Make env vars available to the host machine

* Increase the timeout again

* Bump timeout to 1h for all driver tests

* MongoDB test data config should not hardcode the user and password we use in CI

* Minor test data interface dox improvements

* Support standard deviation and variance for MongoDB

* Oops I got :expressions mixed up with :expression-aggregations

* Note about calculating variance

* `connection-type` instead of `db-or-server`

* Ignore only FE unit test changes in backend workflows

* Ignore both FE and E2E tests

* Simplify filter glob pattern for frontend tests

Take a look at the cheat sheet:
https://docs.github.com/en/actions/using-workflows/workflow-syntax-for-github-actions#filter-pattern-cheat-sheet

'**/docs/**' matches `docs/hello.md` and `dir/docs/my-file.txt`

* Ignore unrelated paths for `backend` workflow even in `master`

* Ignore unrelated paths for `drivers` workflow even in `master`

* Ignore clojure tests in E2E workflows

* Increase the ignored paths scope for `uberjar` workflow

* Migrate some driver tests to GitHub Actions

* Druid
* MariaDB 10.2
* MariaDB latest
* MongoDB 4.0
* MongoDB 5.0
* MongoDB latest
* MySQL 5.7
* Postgres 9.6
* Postgres latest
* Presto
* Spark
* SQLite
* SQL Server 2017

* Don't use Buildjet runner

* Don't run the driver tests for draft PRs

* Use Buildjet for Spark driver tests

* Use Buildjet for Druid driver tests