import { pool } from '@/backend/utils/db';
import { RowDataPacket } from 'mysql2';

/**
 * Typed query helper for MySQL that ensures safe casting
 */
export async function typedQuery<T>(sql: string, params: any[] = []): Promise<T[]> {
  const [rows] = await pool.query<RowDataPacket[]>(sql, params);
  return rows as T[];
}