Relocate traditional-field-encryption and what-searchable-encryption-solves
from the un-navigated how-it-works/ dir into concepts/, and order the
section problem -> motivation -> mechanism.

…ting Started

Update the section title in meta.json and the landing page, and reorder the
top-level nav so the section sits directly under Getting Started.

…works

Rename content/docs/concepts -> content/docs/how-it-works so URLs match the
section name. Update the top-level nav key, all internal /concepts links
(leaving /reference/eql/core-concepts untouched), the three "Concepts"
section labels, and the /concepts destinations in v2-redirects.mjs. Add
/concepts -> /how-it-works redirects (307) so the previously-live preview
URLs still resolve.

Rename traditional-field-encryption -> why-field-encryption-fails and
what-searchable-encryption-solves -> making-encryption-searchable, and add
sql-support, key-management, and cryptography stub pages. Reorder the nav to
match. Work in progress — several pages are still TODO stubs.

…-fails

Replace the TODO placeholders with worked pgcrypto examples:

- pgp_sym_encrypt INSERT and pgp_sym_decrypt SELECT, keeping the secret
  key inline to set up the key-in-the-query point
- a search-by-email query that encrypts the term with the same key and
  still returns 0 rows
- a same-value-twice pgp_sym_encrypt SELECT showing two different
  ciphertexts, demonstrating why equality, GROUP BY and JOIN break

Claude-Session: https://claude.ai/code/session_01NkxKebM3qffTB7FayXsfxP

…ction

Fill in the WHERE-on-pgp_sym_decrypt example (the earlier failed email
lookup now succeeds), explain why it forces a full table scan, then show
that a functional index does work but writes the decryption key verbatim
into the index expression, visible via \d, pg_indexes, and pg_dump.

Output verified against Postgres 17 + pgcrypto.

Claude-Session: https://claude.ai/code/session_01NkxKebM3qffTB7FayXsfxP

- Prose body copy: warm near-white -> cool gray (hsl 240), 14px, tighter
  line-height. Headings, links, and bold keep the full foreground.
- Shift all text tokens off the warm hue 42 to a cool 240 at low saturation.
- Page description under the H1: size down to text-base and use the same
  muted-foreground the sidebar nav items use.

Claude-Session: https://claude.ai/code/session_01NkxKebM3qffTB7FayXsfxP

…light

Enable transformerMetaHighlight so `{n}` line highlighting works in code
fences (Fumadocs bundles only the comment-marker notation transformers,
which don't work in plain ```text blocks). Pin @shikijs/transformers to
match fumadocs.

Use it to highlight the index line that exposes the pgcrypto key in \d
output, replacing the hand-aligned ASCII caret. Also picks up copy tweaks
on the page.

Claude-Session: https://claude.ai/code/session_01NkxKebM3qffTB7FayXsfxP

Replace the two TODOs in "Key management sucks" with worked examples: a
TypeScript + pg snippet threading the env-var key through encrypt/decrypt
queries, and a Postgres statement-log line exposing that key in the
DETAIL parameters.

Claude-Session: https://claude.ai/code/session_01NkxKebM3qffTB7FayXsfxP