DeepSource
Dashboard Resources Pricing Discover Directory Log in

Run your first analysis.

Find thousands of code security and quality issues in your codebase, before they end up in production.

Start now
All analyzers SQL
SQL

SQL

Use Analyzer
Docs
Discuss

Categories

Programming language

Latest version

v0.4.0

Updated on

Mar 21, 2023

Issues

55

Read full documentation

Sample configuration


version = 1

[[analyzers]]
name = "sql"

Stats


Anti-pattern

8

Bug risk

3

Style

44

Issues


View all
Keyword used as an identifier SQL-L029
Bug risk

Keywords should not be used as identifiers.

Unqualified references SQL-L027
Bug risk

References should be qualified if SELECT has more than one referenced table/view. NB: Except if they’re present in a USING clause.

Unused table alias SQL-L025
Anti-pattern

Tables should not be aliased if that alias is not used. An usused alias makes code harder to read without changing any functionality.

Duplicate table aliases SQL-L020
Anti-pattern

Table aliases should be unique within each clause. It is recommended to name the aliases differently.

Column expression without alias detected SQL-L013
Anti-pattern

It is recommended to use explicit AS clause for column expressions.