references/d1/api.md
D1 API Reference
Fetch the relevant API page before writing queries or assuming method signatures and return types.
| Task | Current documentation | | --- | --- | | Bind values and choose a query execution method | Prepared statement methods | | Execute batches and understand transaction rollback; use database sessions | D1 Database API | | Interpret results and query metadata | Return objects | | Choose supported JavaScript values and TypeScript result types | Workers Binding API | | Choose consistency constraints and carry bookmarks between requests | Read replication and Sessions API | | Query from a server-side script outside Workers | REST query API | | Handle query failures and transient errors | Debug D1 and retry queries | | Test database queries and apply migrations in tests | Workers Vitest APIs: D1 |
Bind untrusted values with prepared statements; do not interpolate them into SQL. Parameters do not replace identifiers: choose dynamic table, column, or sort names from an application-controlled allowlist.
D1 sessions provide sequential consistency for replicated queries. They are not a way to extend query execution limits. Choose the starting constraint or bookmark from the application's consistency requirements using the replication guide.