[WIP] Timezones

[zachstence]

Description

This PR will have several changes to make timezones easier to understand and work with in Evidence

Next steps

@archiewood Has made a diagram for the eventual timezone behavior we should work toward (may change as we get deeper into the woods)

• @archiewood @hughess QA how this change behaves with different use cases and different databases
• @archiewood Document what changes the user should make to their data/sources to accommodate this breaking change
• @archiewood Create a page in the evidence docs for Timezones as a whole

[changeset-bot[bot]]

🦋 Changeset detected

Latest commit: 7192367ee4bde9711355157db6b334448e71e9ae

The changes in this PR will be included in the next version bump.

This PR includes changesets to release 6 packages

Name	Type
@evidence-dev/component-utilities	Major
evidence-test-environment	Patch
@evidence-dev/evidence	Major
@evidence-dev/core-components	Patch
my-evidence-project	Patch
@evidence-dev/components	Patch

Not sure what this means? Click here to learn what changesets are.

Click here if you're a maintainer who wants to add another changeset to this PR

[netlify[bot]]

✅ Deploy Preview for evidence-test-env ready!

Name	Link
🔨 Latest commit	7192367ee4bde9711355157db6b334448e71e9ae
🔍 Latest deploy log	https://app.netlify.com/sites/evidence-test-env/deploys/667f15305e0b3000088f8a05
😎 Deploy Preview	https://deploy-preview-2163--evidence-test-env.netlify.app
📱 Preview on mobile	Toggle QR Code... Use your smartphone camera to open QR code link.

---

To edit notification comments on pull requests, go to your Netlify site configuration.

[netlify[bot]]

✅ Deploy Preview for next-docs-evidence ready!

Name	Link
🔨 Latest commit	7192367ee4bde9711355157db6b334448e71e9ae
🔍 Latest deploy log	https://app.netlify.com/sites/next-docs-evidence/deploys/667f15308beb7900089551b4
😎 Deploy Preview	https://deploy-preview-2163--next-docs-evidence.netlify.app
📱 Preview on mobile	Toggle QR Code... Use your smartphone camera to open QR code link.

---

To edit notification comments on pull requests, go to your Netlify site configuration.

[netlify[bot]]

✅ Deploy Preview for evidence-development-workspace ready!

Name	Link
🔨 Latest commit	7192367ee4bde9711355157db6b334448e71e9ae
🔍 Latest deploy log	https://app.netlify.com/sites/evidence-development-workspace/deploys/667f1530f3927f000812e397
😎 Deploy Preview	https://deploy-preview-2163--evidence-development-workspace.netlify.app
📱 Preview on mobile	Toggle QR Code... Use your smartphone camera to open QR code link.

---

To edit notification comments on pull requests, go to your Netlify site configuration.

[archiewood]

I've started adding tests for each data source.

• [x] Snowflake
• [x] BigQuery
• [x] Postgres
• [x] DuckDB
• [ ] Databricks
• [ ] MySQL
• [ ] MS SQL
• [ ] Redshift
• [ ] Trino

These are helpful as they also allow you to confirm the syntax a user needs to use to convert their timezones to UTC in source queries.

I've done a v1 docs page, but want to add the user conversion syntax too

[ItsMeBrianD]

@zachstence @archiewood what's the status of this?

[archiewood]

awaiting tagged release of DuckDB wasm so we can add ICU support