Skip to main content

Auto-Completions

Querylab.io provides intelligent SQL completions as you type.

Completions dropdown

Triggering Completions​

ActionHow
AutomaticAppears as you type
ManualPress Ctrl+Space
AcceptTab or Enter
DismissEscape

What Gets Completed​

Keywords & Clauses​

Multi-word keywords complete as full phrases:

  • GRO → GROUP BY
  • LEF → LEFT JOIN
  • ORD → ORDER BY
Keyword Completions

Context-aware suggestions after SELECT — shows columns, functions, and keywords relevant to your position:

SELECT Completions

Tables & Columns​

Tables from your BigQuery schema and CTEs defined in the query. Column completions appear after you reference a table in FROM clause.

Column suggestions filtered by table context in WHERE clause:

WHERE Completions

Functions​

BigQuery functions with signature help showing parameters and types:

Signature Help

Complex Types (STRUCT & ARRAY)​

Type . after a STRUCT column to see nested fields:

SELECT profile.| -- shows: name, email, age

After UNNEST, completions show the element's fields.