SQL

SQL

Made by DeepSource

Expected a single whitespace after AS SQL-L023

Style
Minor

A single whitespace is expected after AS in WITH clause.

Bad practice

WITH plop AS(
    SELECT * FROM foo
)

SELECT a FROM plop

Recommended

Add a space after AS, to avoid confusing it for a function.

WITH plop AS (
    SELECT * FROM foo
)

SELECT a FROM plop