DataGrip
 
2023.3
Shortcuts: Windows
Get DataGrip

Code Inspection: Missing column aliases

Last modified: 13 May 2022

Configure inspections: Settings | Editor | Inspections

Show intention actions: AltEnter

Reports queries without explicit aliases in output expressions (for example, in the SELECT statement).

Example (PostgreSQL):

CREATE TABLE foo(a INT, b INT);

SELECT 1, a + 1 AS A2, MAX(b) AS M
FROM foo;

Suppress an inspection in the editor

  1. Place the caret at the highlighted line and press AltEnter or click the Intention action icon.

  2. Click the arrow next to the inspection you want to suppress and select the necessary suppress action.

See also

Procedures