SQL

Benchling AI agents built atop the Benchling platform can cut the time from initial discovery to bringing a drug to patients by half; they rely heavily on SQL with embeddings and evaluate via production traces, challenging the notion that LLMs can't do novel tasks.

本文推荐了五个实际SQL项目，帮助构建数据作品集，涵盖客户流失分析、数据仓库构建等，适合提升SQL实战能力。

Datasette Apps 允许在 Datasette 中运行自定义 HTML 应用，通过沙箱机制保障安全，同时提供强大功能。

Datasette 1.0a31 新增支持执行写入 SQL 和保存存储查询功能，提升数据库交互能力。

This article explores advanced SQL window functions beyond basics, focusing on solving real business problems through four key patterns: running totals, gaps and islands (sessionization), ranking and classification, and data imputation. It provides practical examples and code snippets to illustrate how window functions can be effectively utilized in data analysis and manipulation.

This article shares a 12-month self-study roadmap for transitioning from data analyst to data engineer.

微软研究院发布最新研究，涵盖从SQL自动生成GPU内核、AI匹配肿瘤模型等前沿技术。