Val Town Code SearchReturn to Val Town

189```
190├── backend/
191│   ├── database/
192│   │   ├── migrations.ts    # Schema definitions
193│   │   ├── queries.ts       # DB query functions
248  ```
249
250### Database Patterns
251- Run migrations on startup or comment out for performance
252- Change table names when modifying schemas rather than altering
315
316### SQL Operations
317- **execute-sql** / **sqlite-query**: Execute a SQL query against a SQLite database
318- **execute-sql-batch** / **sqlite-exec**: Execute multiple SQL statements against a SQLite database
319
320## Creating Val Town Projects

97```
98├── backend/
99│   ├── database/
100│   │   ├── migrations.ts
101│   │   └── queries.ts
229#### SQL Operations
23021. **execute-sql** / **sqlite-query**
231    - Description: Execute a SQL query against a SQLite database
232    - Arguments: `statement` (string)
233    - Returns: Query results
234
23522. **execute-sql-batch** / **sqlite-exec**
236    - Description: Execute multiple SQL statements against a SQLite database
237    - Arguments: `statements` (array of strings), Optional: `mode` (string: "read" or "write", default: "read")
238    - Returns: Results of the batch execution