Table names for H2 need to ensure that the English locale is specified
when uppercasing. Using the default locale when uppercasing can lead
to surprising results. Our `SETTING` table is a good example. If the
user has set the locale to Turkish, calling `.toUpperCase` on
"setting" will result in `SETTİNG`, which is not the same as `SETTING`
and will cause an error.

Fixes #8615, fixes #8565

* add :insights to query response

* add last-value to timeseries

* hook up to viz settings

* tweak position

* add SmartScalar to LineAreaBarChart

* lint

* tweak colors and last value style

* Add :previous-value

* show previous value

* add granularity to labels

* proper % change

* smart scalar vis

* return a nil fingerprinter if no insight applies

* responsive dash card layout

* handle flex wrap

* simplify

* past > last

* Correctly handle questions with datatime units

* Add smartsclars to xrays

* Rename SmartScalar -> smartscalar

* Remove unneeded requires

* Update tests [ci all]

* add basic smart scalar viz settings

* More tests

* use column settings for formatting

* only use aggregation column

* icon

* add NoBreakoutError and use for SmartScalar

* init sync styles

* Remove unneeded requires

* silly linter workaround

* remove unused file

* add visualization click to smart scalar

* tweak title and smart value placement on dashboards

* add arrow

* more styling tweaks

* only show comparison value in fullscreen

* fullscreen change tweaks

* fullscreen night mode text

* fullscreen card color

* play down fullscreen change

* scalar titles

* lint and font fixes

* fix tests

* fix down arrow

* actionButtons

* fix alignment

* proper drill through

* pass all data to isSensible

* check for insights

* lint fix

* use destructured data object for scalar isSensible (whoops)

* move night mode colors to colors.css

* Support :year aggregation

* Use :unit to determine step whene possible

* Don't normalize linear function

* CR cleanup

* tweak scalar size at different breakpoints

* Add a missing docstring to `metabase.util.date/date-trunc-units`

When sending an email with an attachment, we write the attachment as a
temp file. This uses the `java.io.File/createTempFile` method. If for
some reason we're not able to write that file, maybe because we don't
have sufficient permissions, that method will throw an
IOException. The IOException doesn't include the path of the file it
was trying to create, which makes it difficult to diagnose and
fix. This commit catches that original IOException and rethrows it
with the path of the temp directory that is being used.

Fixes #8405

This looks to have been introduced by 96b77169. Not all sync steps have
extra metadata (and thus a `log-metadata-fn` function. Unfortunately
this wasn't covered by tests as it was in the body of a `log/debug`
call. This commit fixes the problem and also pulls the logic to verify
it out of that `log/debug` call and into a separate function so that
it can be tested separately.

Also moves the segmented permissions regex to a named var.

Currently i18n'd strings that are defined at compile time only return
english text. This occurs with both system and user locale
strings. For system locale, the locale can be changed via setting, so
we can't rely on the JVM locale on startup to be correct as it may
have changed. For the user locale, it could be different for every
request.

This commit adds two new `tru` and `trs` macros that have the same
name as the `puppetlabs.i18n.core` macros (and thus will be extracted
similarly) but will return a defrecord with a `toString` method. This
delays the conversion of the english text to the translated text until
`str` is invoked. All of the code hasn't been flipped to use the new
i18n macros yet, but this gets it in place and tested for the rest of
the application to be migrated to.

Fixes #8245

This commit adds a flag to allow dates parsed from BigQuery to be
parsed in the JVM's timezone rather than UTC. By default all BigQuery
dates are in UTC but it's possible to modify the timezone via a
function invocation. This flag allows installs that have all of their
queries modifying the timezone in that way to match the actual and
expected timezones via setting the JVM's timezone.

This adds a new table for storing sync metrics and a quartz task for
cleaning up old entries in the table.

For now this only stores sync metrics and metadata for the task
history cleanup task. Going forward our other background tasks would
store information as well to help with debugging/troubleshooting those
tasks.

Fixes #7611

When connecting to a Google service, we identify ourselves with a
string that includes version, hash and branch information. If a user
downloads a Metabase tarball from Github, it won't have that Git
metadata and we will throw a NullPointerException on startup.

This commit just ensures we always have a value for that string, even
when there is no git metadata available.

Fixes #8368

Our existing remappings code didn't work when an MBQL fields clause is
present. Typically that fields clause is populated by the
`add-implicit` middleware, but that doesn't happens with the user
included fields.

Fixes #8270

When POSTing to the `/dataset` endoint, there was code that if the
database was our fake database id (used for nested queries) but that
same check wasn't present for the dataset exports. This commit adds
that check and a test that validates it.

Fixes #8256

The issue was around our usage of `du/format-date` with a built-in
date format (`:date-hour-minute-second-ms`). Those Joda Time date
formatters don't default to the system timezone, which the code
assumed. Instead it defaults to UTC. We have code in the MySQL driver
that works around a MySQL driver bug by converting the date to a
string and then using the MySQL `convert_tz()` function. That code was
converting the date from the system timezone to the report timezone,
rather than UTC, which is what the Joda Time date formatter was
returning.

Fixes #8262

Previously an NullPointerException would be thrown if the Pulse was a
bar graph and the resultset contained a nil value for the x or y
axis. This commit just omits those rows so that it doesn't fail and
renders the data it does have.

Fixes #8260

Ensure that the new nested query FK tests don't run on drivers that
don't support both nested queries and FKs. Also needed to fixup
integer data types for Oracle and a nested order by issue for SQLServer

Mostly this change involves resolving the nested query, then using
that resolved nested query along with the top level breakout clause to
figure out if we need to add more fields to be projected from that
inner query.

The code previously was resolving that nested query but wasn't
resolving the breakouts after and reconciling that fields list. This
also adds some tests for these nested FK scenarios.