Index: database/drizzle/db.ts
===================================================================
--- database/drizzle/db.ts	(revision ea09e98c1561d7948b3e6612bff5f2269a697451)
+++ database/drizzle/db.ts	(revision e729b8837b00e5c0fbe29b756ff8d07dcd34047d)
@@ -7,4 +7,8 @@
 })
 
+pool.on("connect", (client) => {
+    client.query('SET search_path TO pcforge, public');
+});
+
 export const db = drizzle(pool, { schema });
 
Index: database/drizzle/queries/builds.ts
===================================================================
--- database/drizzle/queries/builds.ts	(revision ea09e98c1561d7948b3e6612bff5f2269a697451)
+++ database/drizzle/queries/builds.ts	(revision e729b8837b00e5c0fbe29b756ff8d07dcd34047d)
@@ -100,5 +100,6 @@
             name: buildsTable.name,
             created_at: buildsTable.createdAt,
-            total_price: buildsTable.totalPrice
+            total_price: buildsTable.totalPrice,
+            avgRating: sql<number>`AVG(${ratingBuildsTable.value}::float)`
         })
         .from(buildsTable)