Fixes #32058.

* Cljs/TS wrapper for join fields should handle :all and :none (#32006)

* Split metadata into separate expected-columns method

* MLv2 `joinable-columns`

* Cleanup of options

* Opaque join strategy

* Opaque join strategies, part 2

* MLv2 table-or-card-metadata

* Fix `join-fields` schema while we're at it

* Fix cljs test

* Remove conditional-in-conditional

* Cleanup

* add titile to unsub

* fix spacing

There was a discrepancy between TemplateTag id types as defined in metabase.lib.native (uuid) and metabase.mbql.schema (string). This PR makes string the uniform type for both. This results in errors when code using different specs for the same logical entity is used together. Here's an breaking example:

```
(let [card-id 328 ;; This is a valid card locally
      q   (str "SELECT * FROM {{#" card-id "}} LIMIT 2")
      tt  (lib-native/extract-template-tags q)
      res (qp/process-query
            {:database 1
             :type     :native
             :native   {:query         q
                        :template-tags tt}})]
  (is (some? res)))
```
This will break since the tt generated id is a uuid but process-query expects a string id.

Fixes #31252 

* Migrate notebook aggregations to MLv2 — Operators (1) (#31527)

* Add aggregation types

* Add aggregation TypeScript wrappers

* Move `AggregateStep` to its own directory

* Port basic features to MLv2

* Deprecate `AggregationPopover`

* Fix MLv1's aggregation clause validation

* Fix import

* `requiresField` → `requiresColumn`

* Add basic tests for `AggregationPicker`

* Add `findAggregationOperator` test utility

* Add basic tests for `AggregateStep`

* Make stage index explicit

* Highlight selections, add picker back button

* Use long display name for aggregation clauses

* Remove `React` imports

* Enable temporal bucketing

* Use aggregation JS wrappers

* Fix `Icon` import

* Patch unit test according to BE changes

* Fix E2E test

* Simplify `Aggregation's` `dimension` method

* Fix formatting

* Migrate notebook aggregations to MLv2 — Metrics (2) (#31528)

* Add basic legacy metrics support

* Don't show archived metrics

* Highlight selected metric

* Extract `AggregationPopover` in notebook step

* Fix `onClose` prop

* Fix icon

* Add missing metric types

* Use MLv2 to manage metrics

* Remove legacy query logic

* Add `Aggregatable` type

* Migrate notebook aggregations to MLv2 — Inline expressions (3) (#31529)

* Revert "Remove legacy query logic"

This reverts commit 722804d3a6684762701351c658625b5439c75c2b.

* Use HTML labels in `ExpressionWidget`

* Support inline expressions for aggregations

* Fix import

* Fix picker navigation

* Fix type error

* Remove `ts-expect-error`

* Migrate notebook aggregations to MLv2 — Disable MLv1 validation (4) (#31530)

* Extra Metric tests; include `:description` in the Metric `display-info`

* Add `available-metrics` function & TS wrappers

* Support passing a Metric to `lib/aggregate`

* Include `:selected` information in Metric display info

* Fix indentation

* Revert changes to arithmetic type-of calculation

* Test fixes 

* Address PR feedback

* Address PR feedback

* Update docstring

* MLv2: lib.metadata function simplification

* Kondo

* [MLv2] Native query manipulation functions for raw query and template tags

* Remove circular dependency

* Check extract, rather than recognize

* Copy schema from #31789, fix tests for schema

* Fix test

* Update src/metabase/lib/js.cljs

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

* Update src/metabase/lib/native.cljc

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

* Convert template-tag dimension field to mlv2

* Update src/metabase/lib/schema/template_tag.cljc

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

* Include ::id/snippet

* Add assert for modifying native queries

* sort namespace

---------

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

* Fix resolving inherited columns

* Introduce remove-join function

Part of #30093.

* only try to parse temporal values during xlsx export when effective type is temporal

* add dan's test suggestion

* read is-metabot-enabled setting from env var only

* change visibility back to public

* skip metabot specs

* skip one more spec

* fix BE tests

* fix indentation

* more indentation

---------

Co-authored-by: Aleksandr Lesnenko <alxnddr@gmail.com>

* only load cards and metadata for current dashboard tab

* add e2e test

* refactor

* more refactoring

* fix filters not working

* update e2e test

* fix bug with x-rays

* add dashboard_tab_id to automagic-dashboard response

* use schema check instead

* fix on public dashboards

* remove FE x-ray fix now that BE is fixed

* add test for public dashboards

* fix duplicate request for public dashboards

* fix notification bug

* fix failing unit tests in `reducers.unit.spec.js`

---------

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

The join-alias of joined columns should not escape the stage of the join.

Part of #30093.

[MLv2] filter-clause and aggregation-clause should return a raw MBQL clause, not external op (#31748)

Fixes #
* [MLv2] filter-clause and aggregation-clause should return a raw MBQL clause, not external op

* Add tests for clause fns

* Fix linter

* `:metadata/field` => `:metadata/column`

* Merge master

* Implement `suggested-join-condition`

* Update docstring

* OOOF fix typo in `filter-clause`

* Fix premature i18n lookup

* Address PR feedback

* MLv2 JS join function wrappers

* PR feedback from #31590

* `join-conditions` returns raw MBQL clauses!

* WIP

* Simplify `with-join-alias` and `with-join-fields`

* Simplify join and add with-join-conditions

* Un-revert dev

* Wow! Remove unresolved nonsense.

* Remove dev

* Remove dev

* Test fixes 

* PR feedback

* WIP

* defop doesn't need query or stage-number anymore

* Fix Cljs tests for base PR

* Test fixes 

* Test fix 

* Update JS wrappers

* MLv2: remove the source-table: card__<id> hack once and for all

* MLv2: Handle missing Field metadata as long as it is present in Saved Question metadata

* Address PR feedback

* Implement `suggested-join-condition`

* Update docstring

* OOOF fix typo in `filter-clause`

* Fix premature i18n lookup

* Address PR feedback

* MLv2 JS join function wrappers

* PR feedback from #31590

* `join-conditions` returns raw MBQL clauses!

* WIP

* Simplify `with-join-alias` and `with-join-fields`

* Simplify join and add with-join-conditions

* Un-revert dev

* Wow! Remove unresolved nonsense.

* Remove dev

* Remove dev

* Test fixes 

* PR feedback

* WIP

* defop doesn't need query or stage-number anymore

* Fix Cljs tests for base PR

* Test fixes 

* Test fix 

* Update JS wrappers

MLv2 Join API Simplification; implement `with-join-conditions`; make join `:alias` required (#31679)

* Implement `suggested-join-condition`

* Update docstring

* OOOF fix typo in `filter-clause`

* Fix premature i18n lookup

* Address PR feedback

* MLv2 JS join function wrappers

* PR feedback from #31590

* `join-conditions` returns raw MBQL clauses!

* WIP

* Simplify `with-join-alias` and `with-join-fields`

* Simplify join and add with-join-conditions

* Un-revert dev

* Test fixes 

* initial commit

* add snowplow schema

* change indexmodel to model

* Include refs for all expressions in :fields whenever present
* Remove the :fields clause if only expressions remain in it

* Implement `suggested-join-condition`

* Update docstring

* OOOF fix typo in `filter-clause`

* Fix premature i18n lookup

* Address PR feedback

* MLv2 JS join function wrappers

* PR feedback from #31590

* `join-conditions` returns raw MBQL clauses!

* initial prototype w/out statement count parameter

* new approach

* default-database-role driver method

* migration for connection_impersonations table

* conn impersonation model, API and tests

* impersonation fetch and deletion endpoints

* switch test to t2 with-temp

* read conn impersonation settings from DB

* fix merge issue

* add impersonated key to data perms graph and treat it the same as full self-service access

* include impersonated key in returned permissions graph

* make sure impersonated graph passes StrictDataPerms validation

* fix boolean logic

* make sure impersonated keyword doesnt cause error when deleting gtaps

* clear impersonations as necessary when perms graphs changes

* add impersonation support for postgres

* fix typo

* make sure impersonation updates are a non-lazy seq

* add impersonated-user? fn

* fix impersonation api tests

* fix snippet tests

* fix build & exclude connection impersonations from serialization

* switch a test to use t2.with-temp

* add with-impersonations helper and util tests

* move macro and add a connection impersonation driver-level test for postgres

* fix rebase issue

* more tests and code reorganization

* add snowflake test

* clarify comment

* fix lint errors

* fix final kondo error

* reorganization

* fix one test

* fix lint errors

* revert change to sql_jdbc.execute from bad merge

* make sure perms for all users gets reset after conn impersonation tests

* ignore exceptions when restoring perms

* fix postgres test

* refactor to address bryan's comment

* add note about new methods to database changelog

* driver method refactor