Ghost completions

Gray inline text that finishes the part of a query the editor can already predict (an alias, the GROUP BY list, a join condition) so you press Tab instead of typing it. Where the dropdown shows every match, ghost text shows one suggestion, and it disappears the moment you keep typing.

SELECT user_id, country, COUNT(*) AS total
FROM `ace-analytics.warehouse.users`
GROUP BY user_id, country

Accepting and dismissing

SELECT COUNT(*) AS count

• Tab accepts.
• Enter does not accept; it inserts a newline and dismisses.
• Esc or any other key dismisses.

Ghost text and the dropdown can be visible at once. With c¦ount the dropdown also lists count, country, created_at; Tab takes the ghost text, the arrow keys take the dropdown, typing filters both.

Where ghost text appears

Alias after AS

After AS in a SELECT list, the alias is the first letter of each word.

SELECT FactPayment AS fp

• user_accounts AS → ua
• COUNT(*) AS → count
• total_revenue AS → tr

If the alias is taken (say u1) it suggests u2, u3, and so on.

GROUP BY column list

After GROUP BY, every non-aggregate column from your SELECT, in order. One Tab takes all of them. That is the example at the top of this page.

JOIN condition

After JOIN table ON, the condition, when the two tables share exactly one column with the same name and type.

FROM users u
JOIN orders o ON u.user_id = o.user_id

Date filter

For a DATE or TIMESTAMP column in a WHERE clause, the common “last 30 days” filter.

WHERE created_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)

Right side of a join comparison

After the left side of a comparison in an ON clause, the matching column on the other table.

FROM fact_defect fd
JOIN dim_defect_type ddt ON fd.defect_type = ddt.defect_type_key

IS NULL

After IS, NULL. The dropdown still lists both NULL and NOT NULL, so either path works.

WHERE status IS NULL

Closing syntax

When the closing position is deterministic (a parenthesis, a quote), ghost text closes it. Nested parentheses close in the right order.

SELECT (user_id * 100)

Turning it off

Clear Enable ghost completions under Settings → Editor → SQL Editor → Completions.