Hono v4.0(github.com)

  app.post("/signup", async c => {
    const body = await c.req.parseBody();
    const usr = {
      email: body.email.toString(),
      password: sql`crypt(${body.password.toString()}, gen_salt('bf', 8))`,
    } as Record<string, unknown>;
    const [{ usr_id, email, token }] = await sql`
      with usr_ as (insert into usr ${sql(usr)} returning *)
      select usr_id, email, email_token(now(), email) as token from usr_
    `;
    await sendVerificationEmail(email, token);
    await setSignedCookie(c, "usr_id", usr_id, cookieSecret);
    return c.redirect("/u");
  });
  
  app.post("/login", async c => {
    const { email, password } = await c.req.parseBody();
    const [usr] = await sql`
      select *, password = crypt(${password.toString()}, password) AS is_password_correct
      from usr where email = ${email.toString()}
    `;
    if (!usr || !usr.is_password_correct) return c.html(<p>Your password was incorrect.</p>);
    if (!usr.email_verified_at) await sendVerificationEmail(usr.email, usr.token);
    await setSignedCookie(c, "usr_id", usr.usr_id, cookieSecret);
    return c.redirect("/u");
  });