Cleanup some SQL queries

[rowanseymour]

No description provided.

[Copilot]

Pull Request Overview

This PR standardizes SQL query formatting by cleaning up capitalization and spacing inconsistencies. The changes focus on making the SQL code more consistent with standard conventions.

• Standardized keyword capitalization (AS, FROM, WHERE, SELECT)
• Removed unnecessary column aliases where the alias matches the column name
• Improved overall SQL formatting consistency

Reviewed Changes

Copilot reviewed 2 out of 2 changed files in this pull request and generated 2 comments.

File	Description
archives/runs.go	Cleaned up SQL query formatting with consistent AS keyword usage and removed redundant column aliases
archives/messages.go	Applied consistent SQL formatting standards including proper keyword capitalization and alias standardization

---

_{Tip: Customize your code reviews with copilot-instructions.md. Create the file or learn how to get started.}

[codecov]

Codecov Report

✅ All modified and coverable lines are covered by tests.
✅ Project coverage is 59.11%. Comparing base (769e38d) to head (56aab9a).

Additional details and impacted files

@@           Coverage Diff           @@
##             main     #121   +/-   ##
=======================================
  Coverage   59.11%   59.11%           
=======================================
  Files           7        7           
  Lines        1311     1311           
=======================================
  Hits          775      775           
  Misses        430      430           
  Partials      106      106           

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

🚀 New features to boost your workflow:

• ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.