Writing statements
The console knows the schema it is open on: it offers names as you type, quietly marks a table it has never heard of, and lays a statement out without changing what it says.
Completion
The list offers the language’s keywords, types and built-in functions; the schemas, tables and columns the window has read; and, first of all, the columns of the tables the current statement already names in its FROM. After name. it offers only that table’s columns, or that schema’s tables.
What it knows is what has been read: when a connection opens, every schema’s name and the tables and columns of the default one; another schema’s tables arrive once you open it in the tree. On Oracle, SAP HANA and Snowflake, which keep unquoted names in capitals, a name typed in the other case is found too.
Settings → Editor → Suggestions opens the list As you type or only When asked; Ctrl+Space opens it either way. Redis and MongoDB consoles are not SQL, and have no SQL completion.
Names it does not know
A table after from, join, into, using, update, truncate or copy that the schema does not hold gets a faint wavy underline, and so does a column written as table.column or alias.column that the table lacks. It stays silent about anything it has not read yet, about names from WITH and subqueries, and about bare column names, so an underline means the name really is not there.
Formatting
Format statement, Ctrl+Alt+L, lays out the selection, or the statement under the cursor when nothing is selected; never the whole console. It changes only spaces, line breaks and indentation, and the case of keywords as Settings → Editor → Keyword case says: lower, UPPER or As typed.
Find and replace
Find in console, Ctrl+F, and Replace in console, Ctrl+R, search the console’s text. To search a result’s rows, see Find in result; to search the database itself, Search the database.
SQL files
A console can be a file of your own. New script (Ctrl+N), Open a SQL file… (Ctrl+O), Save (Ctrl+S) and Save as… (Ctrl+Shift+S) work as they do in any editor, and closing the window with a file unsaved asks first. A file kept under git shows what changed since its last commit: see Projects and git.
The editor’s line wrapping, tab width, type size and line numbers are on Settings → Editor.