LET $vec = fn::embed("running shoes");

SELECT
  ->purchased->product AS history,
  ->reviewed->product[WHERE
    vector::similarity::cosine(
      embedding, $vec
    ) > 0.8
  ] AS relevant,
  ->prefs[WHERE valid_at <= time::now()] AS prefs
FROM ONLY $user;

BEGIN TRANSACTION;

LET $order = CREATE order SET
  user = $auth.id,
  product = product:headphones,
  total = product:headphones.price;

RELATE $auth.id->purchased->product:headphones
  SET at = time::now();

UPDATE product:headphones SET stock -= 1;

COMMIT TRANSACTION;

DEFINE ACCESS account ON DATABASE
  TYPE RECORD
  SIGNUP (
    CREATE user SET
      email = $email,
      pass = crypto::argon2::generate($pass)
  )
  SIGNIN (
    SELECT * FROM user WHERE
      email = $email AND
      crypto::argon2::compare(pass, $pass)
  );

DEFINE TABLE order PERMISSIONS
  FOR select WHERE user = $auth.id
  FOR create WHERE $auth.id != NONE;