Query Parquet & Iceberg
straight from object storage.

A tiny TypeScript read core — small enough for Cloudflare Workers and the edge, where DuckDB-WASM and JVM engines are too heavy. It either reads correctly or rejects precisely.

npm install lakeql

live in your browser — nothing leaves this page

source bundled sample · 100 rows

—rows

—fetched

—requests

—ms

Press Run to scan the sample.

comparison datasets

Run the browser benchmark on each query shape.

Open compare

Flights R2 range-read baseline Projection, filters, aggregates, and Top-K on the public 2015 flights file. Spatial WKB GeoParquet predicates Compare bbox, within, contains, and distance queries against DuckDB-WASM spatial. Windows Rank, frames, and QUALIFY Exercise partitioned windows, interval RANGE frames, and filtered aggregates.

window examples

Rank, frame, and compare window queries in the browser.

Open the DuckDB-WASM comparison

Top rows per partition

select region, store_id, amount
from sales.parquet
qualify row_number() over (
  partition by region
  order by amount desc, store_id asc
) <= 3

Running aggregate frame

select region, store_id, amount,
  sum(amount) over (
    partition by region
    order by amount asc
    rows between 2 preceding and current row
  ) as moving_amount
from sales.parquet

Timestamp RANGE frame

select account, id, amount,
  sum(amount) over (
    partition by account
    order by event_ts
    range between interval '1 day' preceding
      and current row
  ) as day_amount
from window_events.parquet

Range reads, not downloads

Every adapter fetches byte ranges. The gauges above show real bytes pulled and HTTP requests issued — watch a limit or a where prune the scan.

Three surfaces, one core

The same plan runs from SQL, the fluent builder, or a versioned JSON query. Pick whichever fits the layer you're building.

Honest about limits

Unsupported table features throw a typed LakeqlError with a stable code instead of returning quietly wrong rows.

Query Parquet & Iceberg straight from object storage.