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

Navios

10 de abril de 2026 às 01:46 UTC

Autor

lawrence3699

Enviar

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