Skip to main content

Introduction

This project analyses SQL statements and labels possible errors or complications.

Credits

Special thanks to Davide Miggiano and Flavio Venturini for their valuable contributions to the development of this project.

Limitations

  • Fully identified schema names are not supported when specifying column names (e.g. SELECT schema.table.column [...])

SQL Errors TODO List

Syntax Errors

ID Category Name Description Base Query Subquery CTE
1 SYN-1 Ambiguous database object Omitting correlation names ✓
2 SYN-1 Ambiguous database object Ambiguous column ✓
3 SYN-1 Ambiguous database object Ambiguous function
4 SYN-2 Undefined database object Undefined column ✓ ✓ ✓
5 SYN-2 Undefined database object Undefined function ✓ ✓ ✓
6 SYN-2 Undefined database object Undefined parameter ✓ ✓ ✓
7 SYN-2 Undefined database object Undefined object ✓ ✓ ✓
8 SYN-2 Undefined database object Invalid schema name ✓
9 SYN-2 Undefined database object Misspellings ✓
10 SYN-2 Undefined database object Synonyms
11 SYN-2 Undefined database object Omitting quotes around character data ✓ ✓ ✓
12 SYN-3 Data type mismatch Failure to specify column name twice
13 SYN-3 Data type mismatch Data type mismatch ✓
14 SYN-4 Illegal aggregate function placement Using aggregate function outside SELECT or HAVING ✓ ✓ ✓
15 SYN-4 Illegal aggregate function placement Grouping error: aggregate functions cannot be nested ✓ ✓ ✓
16 SYN-5 Illegal or insufficient grouping Grouping error: extraneous or omitted grouping column ✓ ✓ ✓
17 SYN-5 Illegal or insufficient grouping Strange HAVING: HAVING without GROUP BY ✓ ✓ ✓
18 SYN-6 Common syntax error Confusing function with function
19 SYN-6 Common syntax error Using WHERE twice ✓ ✓ ✓
20 SYN-6 Common syntax error Omitting the FROM clause ✓ ✓ ✓
21 SYN-6 Common syntax error Comparison with NULL ✓ ✓ ✓
22 SYN-6 Common syntax error Omitting the semicolon ✓ ✓ ✓
23 SYN-6 Common syntax error Date time field overflow
24 SYN-6 Common syntax error Duplicate clause
25 SYN-6 Common syntax error Using an undefined correlation name
26 SYN-6 Common syntax error Too many columns in subquery
27 SYN-6 Common syntax error Confusing table names with column names
28 SYN-6 Common syntax error Restriction in SELECT clause (e.g., SELECT fee > 10) ✓ ✓ ✓
29 SYN-6 Common syntax error Projection in WHERE clause (e.g., WHERE firstname, surname) ✓ ✓ ✓
30 SYN-6 Common syntax error Confusing the order of keywords (e.g., FROM customer SELECT fee) ✓
31 SYN-6 Common syntax error Confusing the logic of keywords (e.g., grouping instead of ordering)
32 SYN-6 Common syntax error Confusing the syntax of keywords (e.g., LIKE (‘A’, ‘B’)) ✓ ✓ ✓
33 SYN-6 Common syntax error Omitting commas ✓ ✓ ✓
34 SYN-6 Common syntax error Curly, square or unmatched brackets ✓ ✓ ✓
35 SYN-6 Common syntax error IS where not applicable
36 SYN-6 Common syntax error Nonstandard keywords or standard keywords in wrong context
37 SYN-6 Common syntax error Nonstandard operators (e.g., &&, || or ==) ✓ ✓ ✓
38 SYN-6 Common syntax error Additional semicolon ✓ ✓ ✓

Semantic Errors

ID Category Name Description Base Query Subquery CTE
39 SEM-1 Inconsistent expression AND instead of OR (empty result table) ✓
40 SEM-1 Inconsistent expression Implied, tautological or inconsistent expression
41 SEM-1 Inconsistent expression DISTINCT in SUM or AVG ✓ ✓ ✓
42 SEM-1 Inconsistent expression DISTINCT that might remove important duplicates
43 SEM-1 Inconsistent expression Wildcards without LIKE ✓ ✓ ✓
44 SEM-1 Inconsistent expression Incorrect wildcard: using _ instead of % or using, e.g., * ✓ ✓ ✓
45 SEM-1 Inconsistent expression Mixing a > 0 with IS NOT NULL or empty string with NULL ✓ ✓ ✓
46 SEM-2 Inconsistent join NULL in IN/ANY/ALL subquery
47 SEM-2 Inconsistent join Join on incorrect column (matches impossible)
48 SEM-3 Missing join Omitting a join
49 SEM-4 Duplicate rows Many duplicates
50 SEM-5 Redundant column output Constant column output ✓
51 SEM-5 Redundant column output Duplicate column output ✓

Logical Errors

ID Category Name Description Base Query Subquery CTE
52 LOG-1 Operator error OR instead of AND ✓ ✓ ✓
53 LOG-1 Operator error Extraneous NOT operator
54 LOG-1 Operator error Missing NOT operator
55 LOG-1 Operator error Substituting existence negation with <>
56 LOG-1 Operator error Putting NOT in front of incorrect IN/EXISTS
57 LOG-1 Operator error Incorrect comparison operator or incorrect value compared ✓ ✓ ✓
58 LOG-2 Join error Join on incorrect table
59 LOG-2 Join error Join when join needs to be omitted
60 LOG-2 Join error Join on incorrect column (matches possible)
61 LOG-2 Join error Join with incorrect comparison operator
62 LOG-2 Join error Missing join
63 LOG-3 Nesting error Improper nesting of expressions
64 LOG-3 Nesting error Improper nesting of subqueries
65 LOG-4 Expression error Extraneous quotes
66 LOG-4 Expression error Missing expression ✓ ✓ ✓
67 LOG-4 Expression error Expression on incorrect column ✓ ✓ ✓
68 LOG-4 Expression error Extraneous expression ✓ ✓ ✓
69 LOG-4 Expression error Expression in incorrect clause
70 LOG-5 Projection error Extraneous column in SELECT ✓ ✓ ✓
71 LOG-5 Projection error Missing column from SELECT ✓ ✓ ✓
72 LOG-5 Projection error Missing DISTINCT from SELECT
73 LOG-5 Projection error Missing AS from SELECT
74 LOG-5 Projection error Missing column from ORDER BY clause ✓
75 LOG-5 Projection error Incorrect column in ORDER BY clause ✓
76 LOG-5 Projection error Extraneous ORDER BY clause ✓
77 LOG-5 Projection error Incorrect ordering of rows ✓
78 LOG-6 Function error DISTINCT as function parameter where not applicable
79 LOG-6 Function error Missing DISTINCT from function parameter
80 LOG-6 Function error Incorrect function
81 LOG-6 Function error Incorrect column as function parameter

Complications

ID Category Name Description Base Query Subquery CTE
82 COM Complication Unnecessary complication
83 COM Complication Unnecessary DISTINCT in SELECT clause ✓ ✓ ✓
84 COM Complication Unnecessary join ✓
85 COM Complication Unused correlation name
86 COM Complication Correlation names are always identical
87 COM Complication Unnecessarily general comparison operator
88 COM Complication LIKE without wildcards ✓ ✓ ✓
89 COM Complication Unnecessarily complicated SELECT in EXISTS subquery
90 COM Complication IN/EXISTS can be replaced by comparison
91 COM Complication Unnecessary aggregate function
92 COM Complication Unnecessary DISTINCT in aggregate function
93 COM Complication Unnecessary argument of COUNT
94 COM Complication Unnecessary GROUP BY in EXISTS subquery
95 COM Complication GROUP BY with singleton groups
96 COM Complication GROUP BY with only a single group
97 COM Complication GROUP BY can be replaced with DISTINCT
98 COM Complication UNION can be replaced by OR
99 COM Complication Unnecessary column in ORDER BY clause ✓
100 COM Complication ORDER BY in subquery
101 COM Complication Inefficient HAVING
102 COM Complication Inefficient UNION
103 COM Complication Condition in the subquery can be moved up
104 COM Complication Condition on left table in LEFT OUTER JOIN
105 COM Complication OUTER JOIN can be replaced by INNER JOIN

Detected error messages

Every DetectedError requires a non-empty, plain-language message. Detectors provide an explanation of the specific finding, including the relevant SQL names or expressions. The data tuple remains available for structured details.

DetectedError(
    SqlErrors.UNDEFINED_COLUMN,
    data=('student_age',),
    message='The column student_age could not be found in the available tables.',
)

Message wording follows the SQLerrors taxonomy and the individual definitions linked from it. Messages describe the observed problem and its SQL context without guessing the student's intent. message is a required dataclass field; detectors supply it explicitly.

Metadata

Release files for sqlchecker 1.2.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for sqlchecker 1.2.0
File Size Uploaded Provenance Actions
sqlchecker-1.2.0.tar.gz 132.5 kB Without provenance Details for sqlchecker-1.2.0.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for sqlchecker 1.2.0
File Interpreter ABI Platform Actions
sqlchecker-1.2.0-py3-none-any.whl Python 3 none any Details for sqlchecker-1.2.0-py3-none-any.whl

Total release size: 169.5 kB

Release files / sqlchecker-1.2.0.tar.gz

Download URL sqlchecker-1.2.0.tar.gz
Size 132.5 kB
Tags Source
SHA-256 checksum
How to use checksums
667decfa37d6e10b666d6c35fa83f658106cce465013ab83332ea5661b2b69e6
BLAKE2b-256 checksum
How to use checksums
5aaa99adf25628b4166ef184bfa7da01cb9cd7ee3d9d8d84b16814bb40abd876
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.14.4

Release files / sqlchecker-1.2.0-py3-none-any.whl

Download URL sqlchecker-1.2.0-py3-none-any.whl
Size 37.1 kB
Tags Python 3
SHA-256 checksum
How to use checksums
6f3efaa89d106ded10718c2de7846f328b2a27472918347e802da8b9e720c8a6
BLAKE2b-256 checksum
How to use checksums
6d6575f2d0f01468349c42db578c31fb78ddd0738888fcdf2ef10ec2b4ae72b7
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.14.4

Security for sqlchecker 1.2.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page