Add explicit AS keyword for PostgreSQL column alias in session and event queries

Shipped

April 10, 2026 at 1:46 AM UTC

Author

lawrence3699

Commit

3f44ec7

The session and event expanded metrics queries use implicit column aliasing (`${column} name`) which causes a PostgreSQL syntax error when the column name (like `os`) is followed by `name` without `AS`. PostgreSQL parses `os name` ambiguously and fails with: syntax error at or near "name" The sibling file getPageviewExpandedMetrics.ts already uses the correct `${column} as name` pattern. This applies the same fix to the session and event queries. Fixes #3970