Workspace/SQL playground

SQL · demo-users.ndjson

Back to file

Query this file. The results appear below.

Download query results
Highlighted query preview


Save or publish this query


Query limits and engine behavior
Only SELECT and WITH are allowed. Queries use a 30-second DuckDB timeout, a 1,000-row preview and an 8 MiB result limit. Automatic mode selects DuckDB for joins, filters, sorts or aggregates over collections with 250,000+ records; simple queries stay native. First use builds a disk-backed cache. DuckDB spills within the configured memory and temporary storage limits. Use _json for original normalized values. Exports require a complete result.



Table names and columns
Use the table identifiers below. For nested objects, use json_extract(account, '$.region'). Quote identifiers that contain spaces or dots.
demo-users.ndjsonc_f19dc18b7fb48565287b8d99
_record_id · _ordinal · _json · active · amount · category · country · email · id · name · note · profile · role · timestamp · 


Saved queries
Save a query to reuse it or expose it through the API.


Recent queries
Queries you run here appear in this history.