1
Literate SQL
Complex queries are hard to read. Literate SQL is about writing queries that are as easy to read as a good novel.
Markus Winand
SQL has evolved. Beyond the relational model. Discover it now.
- Popular posts
- 8
- Total points
- 1,270
- HN comments
- 632
- Rank
- #1,569 personal
Visit modern-sql.com → RSS feedOn Hacker News Nov 2015 – Oct 2023
2
SQL reserved words – An empirical list
These words cause problems as table or column name
3
Modern SQL: With – Organize Complex Queries
The WITH clause adds named subqueries to SQL queries. WITH is also known as Common Table Expression (CTE).
4
PostgreSQL 11 Reestablishes Window Functions Leadership
PostgreSQL 11 offers the best OVER clause support among its competitors, true procedures, and improvements in FETCH FIRST and XML.
5
Pivot – Rows to Columns
Pivot SQL tables with CASE or FILTER. Turn rows into columns for the entity-attribute-value model (EAV).
6
Three-Valued Logic
Making decision despite missing SQL data (NULL): How to avoid OR…IS NULL in the WHERE clause.
7
The SQL filter clause: selective aggregates
The FILTER clause extends aggregate functions (SUM, AVG, COUNT, etc.) with an additional WHERE clause. Databases not supporting FILTER can use CASE within the aggregate function instead.
8
One Giant Leap for SQL: MySQL 8.0 Released
MySQL is the last major SQL database that has evolved beyond SQL-92 by introducing window functions (OVER) and common table expressions (WITH [RECURSIVE])