QuickQL

QuickQL is a VS Code extension for running .ql files against JSON and CSV data with a Rust query engine and Rust language server.

Query Format

FROM 'example.json'
SELECT count, search
WHERE count = 7
LIMIT 100

CSV works the same way, using the first row as headers:

FROM 'example.csv'
SELECT count, search

Use SELECT * to return every column. If a query only contains FROM, QuickQL also returns every column:

FROM 'example.csv'

SELECT, WHERE, and LIMIT are optional. JSON sources may be a single object or an array of objects. CSV sources must include headers.

Usage

1. Run npm install.
2. Run npm run compile.
3. Run npm run build:rust.
4. Open this folder in VS Code and start the extension host.
5. Open a .ql file and press the play button in the editor title or the CodeLens above the query.

Results open in the bottom QuickQL panel. The Rust engine streams result rows to the extension process over stdout, and the extension keeps paged rows in memory for the virtualized table. No result file is written for normal VS Code query execution.

Completions

The language server suggests query keywords and reads the JSON or CSV file referenced by FROM to suggest field names for SELECT.