Use "with" in select()

// schema
const subcategories = pgTable(
  'Subcategory',
  {
    name: text('name').notNull().unique(),
    id: bigserial('id', { mode: 'number' }).primaryKey(),
    category: integer('category').notNull(),
  }
);

const products = pgTable(
  'Product',
  {
    // Columns
    subcategory: integer('subcategory').notNull()
  }
)

const productsRelations = relations(products, ({ one, many }) => ({
  subcategory: one(subcategories, {
    fields: [products.subcategory],
    references: [subcategories.id],
  }),
}));


// I want to use the "with" that is available in the query API but with select()
const productList = await drizzle.select({
with: {subcategory: true},
})
.from(products)

// schema
const subcategories = pgTable(
  'Subcategory',
  {
    name: text('name').notNull().unique(),
    id: bigserial('id', { mode: 'number' }).primaryKey(),
    category: integer('category').notNull(),
  }
);

const products = pgTable(
  'Product',
  {
    // Columns
    subcategory: integer('subcategory').notNull()
  }
)

const productsRelations = relations(products, ({ one, many }) => ({
  subcategory: one(subcategories, {
    fields: [products.subcategory],
    references: [subcategories.id],
  }),
}));


// I want to use the "with" that is available in the query API but with select()
const productList = await drizzle.select({
with: {subcategory: true},
})
.from(products)