Auto-Completion

AutoCompletion

Auto-completion is on by default. The REPL will pop up a suggestion menu as soon as you start typing. The suggestions are context-sensitive based on the position of the cursor. Eg only tables are suggested after the FROM keyword; only column names are suggested after the WHERE clause.

Smart Completion

We call this context-sensitive completion smart completion. Here are a few examples of smart completion.

Tables

Only table names from the current database are suggested after the FROM keyword.

Columns

Column names from the current table are suggested after the WHERE clause.

Inserts

INSERT statement will suggest the column names.

Aliases

Aliases in the query are resolved and the columns from the table aliases are suggested.

Fuzzy Matching

The completions are matched using a built-in fuzzy algorithm and rapidfuzz.

For example typing 'djmi' will match the table 'django_migrations' because 'djmi' has parts of matching substrings. Here's an example: