* Add more math functions to MBQL [ci drivers]

* Add non-default implementations [ci drivers]

* Add non-default implementations [ci all]

* More lenient schema [ci drivers]

* Add type hints [ci drivers]

* Fix tests [ci all]

* Fix tests [ci all]

* Presto: stddev_samp -> stddev_pop [ci all]

* Fix indentation [ci all]

* Add tests [ci drivers]

* Don't support percentile in H2 [ci drivers]

* Fix tests [ci all]

* Fix mssql [ci drivers]

* FE support for new functions

* Fix mssql [ci drivers]

* Fix mssql [ci drivers]

* Fix unit test

* Implement code review suggestions [ci all]

* Fix vertica [ci drivers]

* FE: add length & rename expt -> exp [ci drivers]

* Don't i18n displayName [ci drivers]

* FE fixes

* Cleanup aggregation/filter type predicates, isStandard, isMetric/isSegment, and isCustom

* Test: alow expressions in filters

* Alow expressions in filters [ci drivers]

* Allow expressions in :between [ci drivers]

* Allow expressions in :inside [ci drivers]

* Fix log [ci drivers]

* h2: use log10 [ci drivers]

* Fix mssql & spark [ci drivers]

* fix hive [ci drivers]

* Don't reuse :percentile name [ci drivers]

* Fix filter methods

Co-authored-by: Tom Robinson <tlrobinson@gmail.com>

*  If a driver returns base type `:type/*` (i.e., unknown type) in column metadata for native query results, attempt to infer better type by scanning values sample
*  Fix NPE in H2 native query results for columns where JDBC metadata `.getColumnClassName` returned nil
*  Rename `annotate/column-info*` to `annotate/merged-column-info` (makes the purpose of the function clearer)

* Fix extracting :minute-of-hour and :hour-of-day from BigQuery TIME columns [ci bigquery]

* Fix extract with unknown temporal types [ci bigquery]

* Upgrade Chevrotain to v6.5.0

* Switch from embedded actions to visitor

* rename tokens to lexer, remove no-longer needed Chevrotain hack from webpack.config.js

* get tests passing again

* progress converting syntax parser

* got intermediate Sum(A) test passing

* more progress on parsing expressions

* get complex expression passing

* prettier

* linting

* Add TokenizedExpression snapshot test

* Add support to parser for recovering whitespace tokens

* Add case clause [ci all]

* fix test [ci all]

* Harden test [ci all]

* More tests [ci all]

* Correctly infer case return type [ci all]

* Fix test [ci all]

* Fix tests [ci all]

* Improved syntax parser

* More parser cleanup + start adding filters and functions

* Add CASE and partial filter support, cleanup tests

* Add string extracts [ci all]

* Typo [ci all]

* Make linter happy [ci all]

* Add regex-match-first [ci all]

* Fix arglist [ci all]

* Fix test [ci all]

* Add sum-where count-where and share support. Refactor aggregation tokens

* Fix tests [ci all]

* Add ns prefixes [ci all]

* Add ns qualifiers [ci all]

* Fix trim [ci all]

* Tests: ensure stable ordering of results [ci all]

* Fix trim [ci all]

* Support only 1-arg trim [ci all]

* Fix ns prefixes [ci all]

* Fix psql [ci all]

* Fix redshift [ci redshift]

* Refactor/simplify grammer to consolidate aggregation, expression, and filter functions

* Add isCase to isExpression

* Directly splice regex pattern for psql & redshift [ci all]

* Fix schema [ci all]

* Redshift: splice replace args [ci redshift]

* Add ns prefix [ci redshift]

* Typo [ci redshift]

* Filter expressions

* Add metrics and segments back in to expressions

* Disable tokenized editing

* Update tests to clojure.test [ci all]

* Add concat to sqlite [ci all]

* Add length [ci all]

* Add missing ns [ci all]

* Fix test [ci all]

* Fix messed up multimethods [ci all]

* Fix mssql [ci all]

* Fix sqlite concat [ci all]

* sqlite: correctly qoute literal strings [ci all]

* Misc improvements to syntax highlighting etc

* Cleanup tests [ci all]

* Reoder defs [ci all]

* Make linter happy [ci all]

* Mongo: add case [ci mongo]

* mongo: fix switch [ci mongo]

* typo [ci mongo]

* Improve syntax highlighter and suggestions

* Mongo: always have default fallback in case [ci mongo]

* Rearrange test to split out ones using expressions [ci mongo]

* Remove uneeded merge [ci all]

* misc

* Much improved syntax highlighting using recovery mode and partial CST

* Improved suggestions

* try monospace font for expressions

* Better typing in parser, various other fixes

* Avoid parsing multiple times

* Fix tests

* Fix tests

* More test fixes

* Special case for UnderlyingRecords drill with sum-where/count-where/share

* switch back to square brackets for identifiers

* change extract to regexextract

* Lift expressions to subselect [ci all]

* Commit on enter

* rename extract to substitute, fix tests

* Refactor [ci all]

* Fix normalization [ci all]

* Correctly handle joins [ci all]

Co-authored-by: Daniel Higginbotham <daniel@flyingmachinestudios.com>
Co-authored-by: Simon Belak <simon@metabase.com>
Co-authored-by: Maz Ameli <maz@metabase.com>

* Replace util fns with ones from (updated) medley

* Clean ns

* Remove QP context cancelf and metadataf functions which aren't needed/used

* Test fixes 

* Port tests from expectations to clojure.test

* Fix docstring

* Added :question template tag type with lookup

* s/question/card/

* Fix typo: s/substitue/substitute/g

* Wrap card query parameter data in a record

Just like `FieldFilter`s.

* Unrelated: Improve test layout

* Add substitution of card query parameters in queries

This implementation is incomplete.

* Finish substitution of card query in parent query

* Basic FE support for question template tags

* Update card ID on tag name update

Also, don't use `\d` in regexes.

* yarn prettier

* Add support for MBQL queries in template tag lookup

* Return query strings directly as tag value

* Fix query type lookup

* Initialize QP store for MBQL→native conversion

* Fix MBQL to native query conversion

* Port tests from expectations to clojure.test

* Add middleware to resolve tables/fields from referenced cards

This needs to happen before `substitute-parameters` in the QP pipeline,
so that `substitute-parameters` can convert any MBQL queries (from
referenced cards) into native queries. Maybe it should be consolidated
with the other resolution steps.

* Use mbql-query util instead of manual query def

* Add docstring to now public function

* Remove unused import

* Fix docstring positioning 



* Clean ns declaration

* Convert tests to clojure.test

* Be more specific about errors we're looking expecting

Invalid queries caused unexpected exceptions to be thrown when checking
permissions.

* Recursively check permissions of referenced queries

* Add incomplete test [WIP]

* Finish permission check test for referenced MBQL queries

* Add tests for referenced native queries perms check

* Clean ns

* Use existing mbql-to-native middleware

Rather than calling driver-specific `mbql->native` directly.

* Fix formatting

* Use more comprehensive qp func for converting query to native

* front end updates

* Check that all referenced queries are from the same db

* Add test for checking db id of referenced MBQL query

* Clean ns

* add metadata and better error states to UI

* move error message beneath the question picker

* Combine `vals`+`filter`+`map` into a single `keep`

* Rename `CardQuery`→`ReferencedCardQuery`

* Cosmetic: fix typo and formatting

* Test substitution of multiple sub-queries

* Test CTE syntax substitution of multiple sub-queries

* Clean ns

* Clean ns

* Simplify referenced card substitution tests

* Test recursive sub-query substitution

* Cosmetic: typos

* Fix parameter names in comments

* Check that queries don't include circular sub-queries

* Clean ns

* Give users a more user-friendly error for circular referencing sub-queries

* Test referencing queries with parameters

* Update src/metabase/query_processor/middleware/resolve_referenced.clj

Co-Authored-By: Maz Ameli <maz@metabase.com>

* Fix error message and combine card name queries

* Wrap sub-query error in a more user friendly explanation

* Cosmetic: function argument alignment

* Test error handling of referenced sub-queries

* Remove unused 1-arity version of `card-subquery-graph`

* Cosmetic: indentation

* Normalize l10n of error messages

* Reuse functions for looking up referenced cards from query

* implement FE PR feedback

* card -> card_id backend changes

* fix tests

* fix another test

* disallow space between # and number

* Align new middleware with newer QP architecture

* Align sub-query error handling with the new QP

It seems like exceptions are handled more consistently in the new QP, so
we can be less hacky.

* (Re)wrap sub-query errors in user-friendly expalanation

* Rename `xformf`→`rff` to align with QP changes

* force cypress click on select placeholder

* move popover attachement and cap its height

* icon spacing

* customize highlighting for template tags

Co-authored-by: Paul Rosenzweig <paulrosenzweig@users.noreply.github.com>
Co-authored-by: Maz Ameli <maz@metabase.com>

[ci drivers]

* Fix test failures [ci drivers]

* Test fixes [ci drivers]

Cast nominator to to float when doing integer division

* Move Liquibase code to different namespace

* Append ENGINE/CHARACTER SET/COLLATE to all MySQL CREATE TABLE statements
[ci mysql]

* Test fixes; make sure read-column impls check for nil [ci drivers]

* Fix BigQuery driver from Leiningen [ci bigquery] [ci sparksql] (#11650)

* Fix SQL Server field filters against boolean Fields.
[ci drivers]

* Test fixes for drivers with no TIME data type
[ci oracle] [ci presto] [ci redshift] [ci snowflake] [ci sparksql]

* Fix boolean field filters for Oracle [ci oracle] [ci sparksql]

Druid: fix HLL aggregation queries