Json as a string

export const decks = mysqlTable("decks", {
    uuid: char("uuid", { length: 36 }).primaryKey(),
    name: varchar("name", { length: 25 }).notNull(),
    cards: json("cards").$type<Card[]>().default([]).notNull(),
    createdAt: timestamp("created_at").defaultNow(),
    updatedAt: timestamp("updated_at").defaultNow(),
});

export const ZodCard = z.object({
    question: z.string("question").max(255).min(6),
    answer: z.string("answer").max(255).min(6),
})
export type Card = z.infer<typeof ZodCard>;

export const decks = mysqlTable("decks", {
    uuid: char("uuid", { length: 36 }).primaryKey(),
    name: varchar("name", { length: 25 }).notNull(),
    cards: json("cards").$type<Card[]>().default([]).notNull(),
    createdAt: timestamp("created_at").defaultNow(),
    updatedAt: timestamp("updated_at").defaultNow(),
});

export const ZodCard = z.object({
    question: z.string("question").max(255).min(6),
    answer: z.string("answer").max(255).min(6),
})
export type Card = z.infer<typeof ZodCard>;

db.query.decks.findFirst({
  where: ((deck, { eq }) => eq(deck.uuid, input.uuid)),
}).then((deck) => deck?.cards || []))

db.query.decks.findFirst({
  where: ((deck, { eq }) => eq(deck.uuid, input.uuid)),
}).then((deck) => deck?.cards || []))