SQL Syntax and Standards

This cluster centers on discussions about SQL's quirky syntax, lack of standardization across dialects, pronunciation debates, and preferences for using plain SQL versus abstractions or tools.

📉 Falling 0.4x Databases
3,044
Comments
20
Years Active
5
Top Authors
#6186
Topic ID

Activity Over Time

2007
4
2008
11
2009
37
2010
87
2011
64
2012
96
2013
114
2014
85
2015
133
2016
178
2017
130
2018
167
2019
227
2020
230
2021
294
2022
269
2023
358
2024
316
2025
231
2026
13

Keywords

OO TABLE AST SQL ycombinator.com stackoverflow.com ODBC JDBC sqlfum.pt LIKE sql sequel table standard sql queries relational database senior write relational database

Sample Comments

cploonker Mar 23, 2012 View on HN

SQLDidn't realize SQL was an option too.

bombcar Aug 19, 2023 View on HN

This is where pronouncing SQL as squirrel would help.

xapata Sep 11, 2022 View on HN

Different. SQL's syntax is funky.

jabagawee Sep 25, 2024 View on HN

As I understand it, it's not part of the SQL standard.

KronisLV Aug 29, 2024 View on HN

This feels like this should be in the official SQL standard and supported across a bunch of RDBMSes and understood by IDEs, libraries and frameworks.

BrandonLive Oct 31, 2016 View on HN

It is impossible to know just from the fact that it's using SQL...

dumbfounder Oct 1, 2020 View on HN

It's SQL, if they were giving wrong answers people would notice.

jcun4128 Oct 7, 2021 View on HN

Was surprised it's SQL but guess that makes sense/faster to be done there

irrational May 3, 2019 View on HN

"Things that should not be in the SQL Standard, but are." FTFY

331c8c71 Jun 28, 2023 View on HN

Me neither... Must be an sql dialect.