sql

• SQL Cheat-Sheet for Data Science (link)
• Use The Index, Luke (link)
• Modern SQL (link)
• SQL Style Guide (link)
• Learning SQL - Medium.com (link)
• A Brief History of SQL & The Rise of Graph Queries (link)

window functions

• SQL Window Functions: Ranking (link)
• Anatomy of SQL Window Functions (link)
• Understand SQL Window Functions Once and For All (link)

cypher

• openCypher (link)

gql

• GQL Standard (link)

shortest path etc. in sql

• sqlite forum (link)
• mysql (link)
• oracle - long discussion (link)
• brandan’s blog (link)
• duckdb (link)
• postgres (link)

other

• What if an SQL Statement Returned a Database? (link)
• A Gentle(-ish) Introduction to Worst-Case Optimal Joins (link)
• Some opinionated thoughts on SQL databases (link)
• SQL:2023 is finished: Here is what’s new (link)
• How To Create Pivot Tables In SQL (link)
• How to write complex SQL queries with universal quantification (link)
• SQL Best Practices (link)
• Cathy Tanimura SQL Book - git (link)
• Brendan’s repo for interesting SQL (link)
• SQL do’s and don’ts (link)
• 11 SQL Query Optimization Techniques commonly used in Projects (link)
• SQL LATERAL JOIN – A Beginner’s Guide (link)
• PostgreSQL’s Powerful New Join Type: LATERAL (link)
• PostgreSQL’s LATERAL JOIN (link)
• SQLGlot (link)
• sqlparse (link)
• sqloxide (link)
• More SQL Parsing! (link)
• ZetaSQL - Analyzer Framework for SQL (link)
• A Complete Guide to SQL for Data Science (link)
• Take your SQL from Good to Great: Part 1 - Common Table Expressions (link)
• Take your SQL from Good to Great: Part 2 - All about those dates (link)
• Take your SQL from Good to Great: Part 3 - Joins (link)
• whale - lightweight, CLI-first SQL workspace (link)
• Modernes SQL: mehr als relational (link)