Queries

Query examples

Real questions answered in SQL. Each page shows the query itself, the sources it reads, and how to check what comes back.

Runnable patterns

Trace a phrase on Hacker News with SQL A Scry query pattern for tracing a public phrase through Hacker News by month, distinct authors, and inspectable source rows.Find the first use of a phrase on Reddit with SQL A Scry query pattern for locating the earliest occurrences of a phrase in a subreddit, with author, timestamp, score, and the full comment row attached.Recover a prediction market's full price path with SQL A Scry query pattern for reconstructing a Manifold market's probability history bet by bet, from the per-bet prob_before and prob_after fields.Chart a community's drift along a meaning axis with SQL A Scry query pattern that mints two parallel pole sentences as vectors, takes the balanced axis between them, and averages every LessWrong chunk's projection quarter by quarter, centered on the era mean.Count a term on Hacker News by month, sparkline included, with SQL A Scry query pattern that counts a token on Hacker News month by month and draws the sparkline inside the result set with bar(); the demo term is 'mcp'.Track a two-word topic on Hacker News by month with SQL A Scry query pattern that counts Hacker News items carrying two tokens, 'prompt' and 'injection', month by month since 2023.What the read-only door refuses: DROP TABLE The verbatim refusal Scry returns for a non-SELECT statement: nothing runs, nothing is read, nothing is metered.