SQL

Rethinking SQL ETL for modern data platforms

Databricks consolidates fragmented SQL ETL tools into a unified serverless platform with built-in observability and AI optimization, betting consolidation reduces operational complexity better than point solutions.

Vibin' With Erlang

LLMs generate imperative code that fundamentally clashes with Erlang's declarative paradigm, raising concerns about a race to the bottom in software craftsmanship.

Are LLM agents good at join order optimization?

Databricks and UPenn researchers investigate whether frontier LLM agents can optimize SQL join order selection—a critical but traditionally hard database query optimization problem.

ggsql: A Grammar of Graphics for SQL

Posit released ggsql, an open-source tool that brings grammar of graphics principles to SQL for declarative visualization composition, with integrations across Quarto, Jupyter, Positron, and VS Code.

SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL (2024)

Google Research proposes pipe syntax extension to SQL, enabling modern functional data flow patterns while preserving backward compatibility with decades of existing queries.