Everything about SQL syntax

🧭 Start here: a 6-step reading path

1. Read the overview: SQL syntaxA 5-minute orientation
2. Pick up a classic book: The web application hacker's handbookThe most-reprinted book on the subject
3. Read the landmark paper: Long short‐term memory on abstract syntax tree for SQL injection detectionCited 30 times
4. Go sideways: Select (SQL)A closely related topic
5. Go sideways: Null (SQL)A closely related topic

🏆 Landmark papers (most cited)

• Long short‐term memory on abstract syntax tree for SQL injection detection

  Z. Zhuo, T. Cai, X. Zhang · 2021 · IET Software · 30 citations

• SQL/EER—syntax and semantics of an Entity-Relationship-based query language

  Uwe Hohenstein, Gregor Engels · 1992 · Information Systems · 20 citations

• Quality assessment of GPT-3.5 and Gemini 1.0 Pro for SQL syntax

  Cosmina-Mihaela Rosca, Adrian Stancu · 2026 · Computer Standards & Interfaces · 16 citations

• SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL

  Jeff Shute, Shannon Bales, Matthew Brown · 2024 · Proceedings of the VLDB Endowment · 14 citations

• A Heterogeneous Graph to Abstract Syntax Tree Framework for Text-to-SQL

  Ruisheng Cao, Lu Chen, Jieyu Li · 2023 · IEEE Transactions on Pattern Analysis and Machine Intelligence · 8 citations

• Syntax and Relation Enhanced Query Generation for Text to SQL Parsing

  Kun Han, Xi Xiong · 2024 · Frontiers in Science and Engineering · 1 citations

• The Automatic Marking Method of SQL Script Based on Syntax Analysis and Levenshtein Distance

  霞 刘 · 2014 · Software Engineering and Applications · 1 citations

• Filling Memory Gaps: Enhancing Continual Semantic Parsing via SQL Syntax Variance-Guided LLMs Without Real Data Replay

  Ruiheng Liu, Jinyu Zhang, Yanqi Song · 2025 · Proceedings of the AAAI Conference on Artificial Intelligence · 1 citations

📚 Books worth reading

• The web application hacker's handbookDafydd Stuttard, Marcus Pinto · 2007
• Learning PHP, MySQL & JavaScriptRobin Nixon · 2009
• Access database design & programmingSteven Roman · 1997
• PHP for the World Wide WebLarry Ullman · 2001
• Sams teach yourself SQL in 10 minutesBen Forta · 1999
• Informix Guide to SQLInformix Software · 1994
• Java enterprise in a nutshellJim Farley, David Flanagan · 1999
• Introduction to Computing Using PythonLjubomir Perkovic · 2011

Ranked by number of editions on Open Library, a rough measure of how lasting a book is.

🔗 Related topics

• Select (SQL) The SQL SELECT statement returns a result set of rows, from one or more tables. A SELECT statement retrieves zero or more rows from one or more database…
• Null (SQL) In the SQL database query language, null or NULL is a special marker used to indicate that a data value does not exist in the database. Introduced by the…
• Log trigger In relational databases, the log trigger or history trigger is a mechanism for automatic recording of information about changes inserting or/and updating…
• Insert (SQL) An SQL INSERT statement adds one or more records to any single table in a relational database. Insert statements have the following form: INSERT INTO table…
• Order by An ORDER BY clause in SQL specifies that a SQL SELECT statement returns a result set with the rows being sorted by the values of one or more columns. The…
• SQL Structured Query Language (SQL) (pronounced /ˌɛsˌkjuˈɛl/ S-Q-L; or alternatively as /ˈsiːkwəl/ "sequel") is a domain-specific language used to manage data…
• Merge (SQL) A relational database management system uses SQL MERGE (also called upsert) statements to INSERT new records or UPDATE or DELETE existing records depending…
• Gadfly (database) Free and open-source software portal Gadfly is a relational database management system written in Python. Gadfly is a collection of Python modules that…