Go Database Access

Implement database access for this Go code. Use parameterized queries, handle connection pooling, close rows/statements properly with defer, wrap related operations in transactions, and return meaningful errors on failure. Use the database library already in the project (sqlx, pgx, or GORM).