* move pre-update-check-sandbox-constraints to defenterprise

* fix failing test so that it runs with :sandboxes feture enabled

* Don't load metabase.query-processor-test.test-mlv2 until we load QP

* Add schema and tests for `:value`

* Don't skip tests for #29895

* Conversion logic for `:value`

* pMBQL normalization should handle `:effective-type`

* Options should validate `:base-type`, `:effective-type`, etc. if present

* Use `:effective-type` for type checking if present

The current state is a collection of hacks to preserve some legacy
behavior (eg. normalization sets a blank `widget-type` to `"category"`)
and it doesn't work properly right now.

An example of a currently-broken case:
- `SELECT * FROM Orders WHERE {{tag}}`
- Set it to a Field Filter and select People > LONGITUDE
  - Or some other field for which type we don't have a widget.
- It shows "None" as the widget type, and the widget isn't shown at the
  top.
- Save the question and reopen it.
- Now the widget is visible (and a bit broken) as a `"category"` type.

This is because on reading from the appdb it gets normalized.

This PR uses `"none"` properly for cases where there are no widget
options for the field type (eg. longitude), and updates all the usage
sites to properly handle `"none"` rather than missing/undefined.

Existing saved questions with a blank `widget-type` will continue to
"work" as they currently do.

It was causing issues with query validation when it appeared in
unexpected places (like as the options on an `[:aggregation 0]`
reference.)

* Destructure the stage index in `LimitStep`

* Fix stage index management in notebook

* Generate step test IDs when building a step

* MLv2: finish implementing temporal bucketing

* Sort namespaces

* Sort namespaces

* Fix clj-kondo analysis for `defclause`

* Fix Kondo config

* Fix typo

* wait for db delete request to resolve before closing modal

* more async shenanigans

* Include checklist task to migrate off h2

New checklist item is shown when not hosted and app-db is h2. A
divergence from others, this checklist is not shown if it is not
triggered. In other words, we don't want to show this task as completed
in the UI if they are hosted or using pg, we just want to omit the task
completely. This is because we do not know if they upgraded or just
started with pg/mysql or started in the cloud.

Did lots of cleanup to make this easier to grok and easier to
test. Ultimately we don't have to redef a bunch of stuff to test the
scenarios.

* Fix setup links for external urls

* Re-export

* Add api types

* Add tests

* Improve tests

* Improve tests

* Improve tests

* Improve tests

* Improve tests

* Simplify if

* Show checklist as completed when on pg/mysql and not hosted

was filtering this out as we can't (easily?) tell if an instance was
migrated from h2 -> postgres. So wasn't clear if showing a checked-off
task list item made sense. But it does. So we'll show it. We just wont'
show it in cloud (hosted)

---------

Co-authored-by: Alexander Polyankin <alexander.polyankin@metabase.com>

Added embeddings to preprocess sql completions so that we downselect to an appropriate prompt size. This also gives us substantial performance improvements for model and table matching inference.

This reverts commit 90aa81de.

This reverts commit 8c853374.

It was causing issues with query validation when it appeared in
unexpected places (like as the options on an `[:aggregation 0]`
reference.)

The core logic is still from the release script in bin/release.
The change here mostly wiring it up to GitHub Action so that it can be trigged
upon a new git tag (during the release process).

* Increase the request timeout for Percy model editor spec

* Update e2e/test/visual/models/editor.cy.spec.js

Co-authored-by: Tim Macdonald <tim@metabase.com>

---------

Co-authored-by: Tim Macdonald <tim@metabase.com>

* MLv2: validate references inside queries

* Validate references

* Skip join-alias validation if we have a Card source query

* Test fixes 



* Use `metabase.mbql.util.match` for match stuff

---------

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

* initial changes

* add tests

* remove namespaces

* Update test/metabase/api/user_test.clj

Co-authored-by: Noah Moss <32746338+noahmoss@users.noreply.github.com>

---------

Co-authored-by: Noah Moss <32746338+noahmoss@users.noreply.github.com>

Resolves #29687

* Move `BreakoutStep` to its own directory

* Rearrange props

* Add unit tests