1. Define the database connection using `SQLDatabase` from `encore.dev/storage/sqldb`.
2. Implement database migrations in the `./migrations` directory following the naming convention.
3. Use `db.query` for retrieving multiple rows, `db.queryRow` for a single row, and `db.exec` for operations without a return value.
4. Integrate Drizzle ORM by configuring the schema and drizzle config.
5. Generate migrations using `drizzle-kit generate`.
6. Perform database operations using Drizzle ORM methods like `select`, `insert`, `update`, and `delete`.
7. Ensure SQL injection protection by using template literals for queries.
SynapticSkills