DatabaseInterface.query() return type doesn't expose .rows — forces `as any` in all consumers

[willgriffin]

Problem

DatabaseInterface.query() returns a type that does not expose the .rows property, even though the PostgreSQL driver returns { rows: T[] } at runtime. Every downstream consumer must cast through any to access row data:

const result = await db.query(`SELECT ... FROM ...`, arg);
const rows = (result as any).rows ?? result;  // forced cast

This pattern appears in 5+ files across blindmanpress.com (and likely other consumers), completely defeating TypeScript safety on all raw query results.

Expected Behavior

query() return type should either:

1. Expose .rows directly (e.g., { rows: T[] })
2. Return rows as the top-level array (so no .rows access is needed)
3. Provide a typed queryRows<T>() convenience method

Consumer Impact

Every file using db.query() with raw SQL currently has zero type safety on the result shape. Column renames or schema changes in upstream packages will not produce compile-time errors — only runtime failures.

References

• [blindmanp

const result = await db.query(`SELECT ... FROM ...`, arg);
const rows = (result as any).rows ?? result;  // forced cast
`referrals/links`, `referrals/click`, `affiliates/events`