Skip to main content

Auto-Completions

Querylab.io provides intelligent SQL completions as you type.

Triggering Completions​

  • Automatic — Appears as you type
  • Manual — Press Ctrl+Space
  • Accept — Tab or Enter
  • Dismiss — Escape

What Gets Completed​

Keywords & Clauses​

Multi-word keywords complete as full phrases:

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

Tables & Columns​

From your BigQuery schema and CTEs defined in the query.

Functions​

BigQuery functions with parentheses: COUNT(), DATE_DIFF(), etc.

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.