Exercise 1: The Database-Backed Catch-All — Possible Solution
====================================================================

THE ROUTE
------------------------------
// src/pages/[...path].astro
---
import { db } from '../db/client';
import { pages } from '../db/schema';
import { eq } from 'drizzle-orm';

const { path } = Astro.params;
const fullPath = path ?? '';

const [page] = await db.select().from(pages).where(eq(pages.fullPath, fullPath));
---

<h1>{page.title}</h1>

CONFIRMATION
------------------------------
Given a real row in the pages table with full_path = 'programming/java',
visiting /programming/java in the browser resolves Astro.params.path
to 'programming/java', which the Drizzle query matches exactly
against that row's own full_path column, and the page's real title
renders in the <h1>.

WHY THIS WORKS AS AN ANSWER
------------------------------
It correctly shows the query resolving Astro.params.path against the
pages table's full_path column, and correctly confirms a real stored
page renders its own title at its own matching URL.