What language do you use to write database queries?

SQL (Structured Query Language) is commonly used for writing queries to databases. It allows performing operations such as selection, insertion, updating, and deletion of data. In Go (Golang), the database/sql package is often used along with specific database drivers, where SQL queries are passed as strings.

Example of a simple SQL query in Go:

import (
    "database/sql"
    _ "github.com/lib/pq" // driver for PostgreSQL
)

func getUsers(db *sql.DB) ([]string, error) {
    rows, err := db.Query("SELECT username FROM users")
    if err != nil {
        return nil, err
    }
    defer rows.Close()

    var users []string
    for rows.Next() {
        var username string
        if err := rows.Scan(&username); err != nil {
            return nil, err
        }
        users = append(users, username)
    }
    return users, nil
}