Issues from a WITH clause (CTE).

export const price = pgTable("price", {
  id: uuid().primaryKey().defaultRandom().notNull(),
  name: varchar({ length: 255 }).notNull(),
  buy: integer().notNull(),
  sell: integer().notNull(),
  lastUpdatedAt: timestamp({ withTimezone: true, mode: "string" })
    .defaultNow()
    .notNull(),
});

WITH priceLast as (SELECT name, MAX(price."lastUpdatedAt") as lastUpdatedAt FROM price GROUP BY name)
SELECT 
  price.id as id, 
  priceLast.name as name, 
  priceLast.lastUpdatedAt as lastUpdatedAt,
  price.buy as buy,
  price.sell as sell
FROM priceLast INNER JOIN price ON
priceLast.lastupdatedat = price."lastUpdatedAt" AND priceLast.name = price.name