pub async fn create_demo_database() -> Result<AnyPool, Error>
Creates an in-memory SQLite database with sample tables for demo mode.