Query Builder

Getting started

import { Database } from '@sluice/adbc';
import SluiceDuckDBDialect, { KyselyDuckDB } from '@sluice/kysely-duckdb-adbc';

const adbc = new Database(':memory:');
const db = new KyselyDuckDB({ dialect: new SluiceDuckDBDialect({ database: adbc }) });

Schema, Types and Queries

interface DB {
  person: {
    address: {
      postalCode: string;
      street: string;
    };
  };
}

async function test(db: Kysely<DB>) {
  await db
    .insertInto('person')
    .values({
      address: new JsonValue({
        postalCode: '123456',
        street: 'Kysely avenue 42',
      }),
    })
    .execute();

  await db
    .selectFrom('person')
    .selectAll()
    .where('address', '@>', new JsonValue({ postalCode: '123456', street: 'Kysely avenue 42' }))
    .execute();
}