Skip to content
TopicTracker
From HackerNewsView original
TranslationTranslation

Nobody Reads the SQL Anymore

The article argues that as modern data stacks rely on ORMs, query builders, and AI-generated queries, fewer developers and analysts actually read or write raw SQL, which leads to performance issues, security vulnerabilities, and a loss of deep understanding of how databases work.

Background

- The article discusses how SQL—the standard language for querying databases—has become a "write-only" language in modern data teams. Developers and analysts use ORMs (Object-Relational Mappers like SQLAlchemy, ActiveRecord) or visual BI tools (Looker, Tableau) to generate SQL automatically, meaning the raw SQL is rarely read or reviewed by humans. - It explores the consequences: bugs, security issues, and performance problems go unnoticed because nobody manually inspects the generated queries. The author argues this is a growing blind spot as data complexity increases. - ORMs are popular because they let developers work with databases using their programming language's objects instead of writing raw SQL. BI tools similarly abstract SQL behind drag-and-drop interfaces. This convenience trades off against visibility and control. - The piece matters for anyone building or maintaining data pipelines, because it highlights a cultural and technical gap between the "generation" layer and the "execution" layer of data work.

Related stories