wasm-rquickjs-cli 0.4.2

Tool for wrapping JavaScript modules as WebAssembly components using the QuickJS engine
import assert from 'assert';
import { QueryBuilder, integer, pgTable, serial, text, timestamp } from 'drizzle-orm/pg-core';
import { and, desc, eq, gte } from 'drizzle-orm';

export const run = () => {
  const users = pgTable('users', {
    id: serial('id').primaryKey(),
    name: text('name').notNull(),
    age: integer('age'),
    createdAt: timestamp('created_at').notNull(),
  });

  const qb = new QueryBuilder();
  const compiled = qb
    .select({ id: users.id, name: users.name })
    .from(users)
    .where(and(eq(users.name, 'Ada'), gte(users.age, 18)))
    .orderBy(desc(users.createdAt))
    .limit(3)
    .toSQL();

  assert.strictEqual(
    compiled.sql,
    'select "id", "name" from "users" where ("users"."name" = $1 and "users"."age" >= $2) order by "users"."created_at" desc limit $3',
  );
  assert.deepStrictEqual(compiled.params, ['Ada', 18, 3]);

  return 'PASS: query builder compiles a filtered and ordered select statement';
};