Docs
Playground Open app
Docs /What's new /Release notes
What's new

Release notes

What changed in Querylab.io, newest first.

1.3 Tab to expand, LIMIT suggestions

  • Tab expands SELECT * — The caret on the star, Tab writes out the column list.
  • Diagnostic rules in Settings — Every editor check listed and individually switchable.
  • LIMIT suggestion — A LIMIT offered where it reduces the scan on a clustered table, applied on request.
  • Last used table tab — Tables reopen on the tab you were working in.
  • Performance and stability improvements — Background analysis for long queries, plus bug fixes across the editor and the desktop app.

1.2.9 Pipe syntax support completed

  • Pipe syntax everywhere — Completions, hover, rename, go to definition, checks and lineage for pipe queries.
  • Newer BigQuery syntax — Multi-level aggregation, AI.AGG, hybrid search, search and vector index management.
  • Wider lineage coverage — Struct subfields, correlated subqueries, ARRAY subqueries and SELECT * EXCEPT.
  • Column types in the SELECT list — Each item labelled inline with its type.
  • Mobile notebook editing — SQL cells on iPhone and iPad.

1.2.7 Windows app and Spaces

  • Windows app — A Windows build alongside macOS, with gcloud credential sign-in on desktop.
  • Spaces for everyone — Tabs and projects grouped, with separate billing and visibility per Space.
  • First run — Project connection on web and desktop, or the playground.
  • Estimated against actual bytes — Both numbers shown when a query scans less than estimated.
  • Silent mode — Queries run without Querylab.io labels.
  • Performance improvements — Typing latency in long queries and schema tree scrolling.

1.2.5 Graph queries and charts

  • Graph queries — GQL completions, navigation and checks, with a node and edge view of results.
  • SQL to GQL — A join-heavy query converted to GQL.
  • Charts from SQL — A VISUALIZE clause renders a chart. A Querylab.io extension, not BigQuery syntax, off by default.
  • dbt macros — Expanded as you type for completions, hover and checks.
  • More BigQuery syntax — MATCH_RECOGNIZE, chained PIVOT and UNPIVOT, remote and external functions, CONNECTION, GRANT and EXPORT DATA.
  • Default reservation — A reservation for new query tabs, overridable per query.

1.2.3 Pipe syntax conversion and the Mac app

  • Pipe syntax conversion — Between standard SQL and pipe syntax, with an optional optimize pass.
  • macOS app — A signed Mac app with automatic updates.
  • Per-statement cost — What each statement in a script scans, with organization discounts applied.
  • Import from Sheets, Drive and clipboard — Load data into BigQuery, with descriptions generated for you.
  • More quick fixes — Checks for geography values, comma joins and organization cost guardrails.
  • Performance improvements — Faster editing in long scripts.

1.2 Playground and inline AI edits

  • Playground — The full editor on public BigQuery data without sign-in.
  • Inline AI edits — Changes to the current query reviewed as a diff.
  • dbt and Dataform — Templates compiled, priced and marked up inline.
  • Column lineage — A column traced through CTEs, views and table functions.
  • Notebook sharing — Share by link, bind parameters to cells, copy cells between notebooks.
  • BigQuery AI functions — AI functions, named parameters, UNDROP SCHEMA and GENERATED ALWAYS AS columns.

1.1.5 Notebooks, compare, scheduled queries

  • Compare tab — Two queries or two schemas side by side with differences marked.
  • Scheduled queries — Create, edit and browse scheduled queries, with timezones and run history.
  • Notebooks — SQL, markdown and results in one document, with values passed between cells.
  • Prism AI tools — Schema exploration, query runs and comparisons, saved queries, choice of provider.
  • Import and export — Drag files in. Export to Excel, DuckDB, dbt models, Cloud Storage or the clipboard.
  • Insights panel — Query complexity, slot and reservation recommendations, prices in your currency.

1.1 Prism AI

  • Prism AI — An assistant that works from your schema, in read-only, confirm or autonomous mode.
  • Ghost completions — The rest of the line suggested ahead of the cursor, including joins.
  • Spaces — Separate tabs, pinned tables and a colour theme per project.
  • Query sharing — A link that carries the SQL and opens it in a tab.
  • Value completions — Actual column values suggested in WHERE comparisons.
  • Google Sheets export — Results sent to a new or existing spreadsheet.
  • GA4 datasets — Recognised automatically, with field descriptions and 21 ready-made queries.

1.0 First public release

  • Editor checks — Over twenty checks run as you type.
  • Cost breakdown — A per-column cost estimate for each query, with a 100 GB default ceiling.
  • Query history — Runs kept with cost, job details and the tables involved, reopened with their results.
  • Command palette and split view — Cmd+K for actions, tables and past queries. Tabs side by side.
  • Storage analysis — Storage cost per table, physical and logical billing, partitioning and clustering.
  • Settings — Formatting, completions, editor behaviour and privacy.

0.9 Statement execution and grid rework

  • Single statement execution — Run one statement from a file using gutter icons.
  • Results grid — Column order and width remembered, row numbers across pages, raw JSON tab.
  • Window functions — OVER clauses, named windows and frame specifications.
  • More BigQuery syntax — TABLESAMPLE, FOR SYSTEM_TIME AS OF, ML and SAFE functions, MERGE.
  • Function completions by namespace — ST., ML., NET. and JSON., with snippets for common statements.
  • Quick fixes — Applicable fixes attached to editor warnings.
  • Sharded tables and views — Sharded tables as one entry, view details and query tabs, INFORMATION_SCHEMA queries.
  • Performance improvements — Faster startup on projects with many tables.

0.7 SQL parsing in the browser

  • Local SQL parsing — Completions, hover and checks computed in the browser.
  • Code navigation — Hover, go to definition and find references.
  • Inline warnings — Problems underlined as you type.
  • Wider BigQuery syntax — Pipe syntax, PIVOT and UNPIVOT, SELECT * EXCEPT, ROLLUP, CUBE, GROUPING SETS, arrays and structs.
  • Completions in joins and subqueries — JOIN ON and USING clauses, subqueries, CTEs and qualified names.
  • Pipe syntax conversion — A standard query rewritten as pipe syntax.

0.5 Sign-in, formatting, dark theme

  • Google sign-in — A guided first run from sign-in to a selected project.
  • Demo mode — Public BigQuery data, no project required.
  • SQL formatting — Format a query with one action.
  • SQL generation — SELECT, CREATE and other statements from the schema tree.
  • Dark theme — For the editor, grid and dialogs, stored with your account.
  • Query tabs — Each tab keeps its own SQL and results.

0.3 Column completions and cost estimates

  • Column completions — Columns suggested from the schemas of the tables you reference.
  • Results grid — Merged cells for repeated values, formatted dates and timestamps.
  • Cost estimates — An estimated price for each query before it runs.
  • AI query fixes — A corrected version of a query on request.
  • Browser install — Querylab.io can be installed and opened like a desktop app.
  • Performance improvements — Faster loading for accounts with many datasets and tables.

0.1 First working version

  • SQL editor — BigQuery syntax highlighting and table name completion.
  • Schema sidebar — Projects, datasets and tables in a sidebar.
  • Query results — Results below the editor, loaded page by page.
  • Background jobs — Queries run as BigQuery jobs and continue in the background.