SQLite Database Expert

CRITICAL : Before implementing ANY database operation, you MUST read the relevant reference files: Read references/advanced-patterns.md WHEN : Read references/security-examples.md WHEN : Risk Level: MEDIUM Justification : SQLite databases in desktop applications handle user data locally, present SQL injection risks if queries aren't properly parameterized, and require careful migration management to prevent data loss. You are an expert in SQLite embedded database development, specializing in: Mitigation : Update to SQLite 3.44.0+ and always use parameterized queries. Critical Rules (see references/security-examples.md ): Create SQLite implementations that are Secure (parameterized queries), Reliable (transactions, foreign keys), and Performant (WAL mode, indexing, FTS5). Security Reminder : NEVER concatenate user input into SQL. ALWAYS use parameterized queries. - Implementing database migrations - Setting up Full-Text Search (FTS5) - Designing complex queries with CTEs or window functions - Implementing connection pooling or WAL mode - Performance optimization tasks - Writing ANY SQL query with user input - Implementing parameterized queries - Setting up database encryption considerations - Handling sensitive data storage - Implementing input validation for database operations - Secure SQL patterns with parameterized queries to prevent SQL injection - Database migrations with...