SQL

SQL

Made by DeepSource

Implicit aliasing of table detected SQL-L011

Style
Major

Implicit aliasing of table not allowed. Use explicit AS clause.

Bad practice

In this example, the alias ‘voo’ is implicit.

SELECT
    voo.a
FROM foo voo

Recommended

Add AS to make it explicit.

SELECT
    voo.a
FROM foo AS voo

Ref: https://stackoverflow.com/questions/4164653/whats-the-purpose-of-sql-keyword-as