wasm-rquickjs-cli 0.5.3

Tool for wrapping JavaScript modules as WebAssembly components using the QuickJS engine
import assert from "assert";
import * as Statement from "@effect/sql/Statement";

export const run = () => {
  const compiler = Statement.makeCompilerSqlite();

  const whereClause = Statement.or([
    Statement.and([
      Statement.unsafeFragment("age > ?", [18]),
      Statement.unsafeFragment("active = ?", [1]),
    ]),
    Statement.unsafeFragment("role = ?", ["admin"]),
  ]);

  const [whereSql, whereParams] = compiler.compile(whereClause, false);
  assert.strictEqual(whereSql, "((age > ? AND active = ?) OR role = ?)");
  assert.deepStrictEqual(whereParams, [18, 1, "admin"]);

  const joined = Statement.join(" OR ")([
    Statement.unsafeFragment("name = ?", ["Alice"]),
    Statement.unsafeFragment("email = ?", ["alice@example.com"]),
  ]);
  const [joinedSql, joinedParams] = compiler.compile(joined, false);
  assert.strictEqual(joinedSql, "(name = ? OR email = ?)");
  assert.deepStrictEqual(joinedParams, ["Alice", "alice@example.com"]);

  return "PASS: Statement compiler handles and/or/join fragments";
};