What does a Scry search line compile to?

compilescry_lexsearch
Answer

Readable, editable, index-engaging SQL — POST /v1/scry/compile returns it, scry_lex('<line>') embeds it in any statement, and the search panel's 'as SQL' door shows it.

Methodology

`"prompt injection" after:2025 source:hackernews` compiles to hasToken recall conjuncts plus an exact phrase decider. Paste the WHERE into any shape — counts, histograms, joins. The compiled query is the answer's provenance: the machinery is visible, and anyone can re-run it.

Last verified: 2026-08-27

Query

Run this SQL in Scry to reproduce this answer. Paste into Claude Code with the Scry prompt, or call the API directly.

SELECT title, uri, original_timestamp, original_author, left(search_text_lc, 240) AS text_head FROM hackernews.items WHERE scry_lex('"prompt injection" after:2025') ORDER BY original_timestamp DESC LIMIT 20

Run this query live →

Related questions

How do I query Scry?

Authenticate with a Scry account API key, inspect the live schema, then submit one bounded read-only statement.

How often does Hacker News discuss prompt injection, month by month?

One query, one row per month, a real count in each — not ten links.

Try this query yourself

Create a Scry account, get your personal key from Console, then copy the Scry prompt into Claude Code. Your agent composes the SQL.

Get the Scry prompt