All

type userObj struct {
    ID   int
    Name string
}

ctx := context.Background()
db, err := bob.Open("postgres", "...")
if err != nil {
    // ...
}

q := psql.Select(...)
users, err := bob.All(ctx, db, q, scan.StructMapper[userObj]())
if err != nil {
    // ...
}

type User struct {
    ID    int    `db:"id"`
    Name  string `db:"name"`
    Email string `db:"email"`
}

query := psql.Select("id", "name", "email").
    From("users").
    Where(psql.Quote("active").EQ(psql.Arg(true)))

users, err := bob.All(ctx, db, query, scan.StructMapper[User]())
if err != nil {
    return nil, err
}

fmt.Printf("Found %d users\n", len(users))
for _, user := range users {
    fmt.Printf("User: %+v\n", user)
}

type UserSummary struct {
    ID        int       `db:"id"`
    Name      string    `db:"name"`
    Email     string    `db:"email"`
    CreatedAt time.Time `db:"created_at"`
    PostCount int       `db:"post_count"`
}

query := psql.Select(
    psql.Quote("users", "id"),
    psql.Quote("users", "name"),
    psql.Quote("users", "email"),
    psql.Quote("users", "created_at"),
    psql.F("COUNT", psql.Quote("posts", "id")).As("post_count"),
).From("users").
    LeftJoin("posts", psql.Quote("posts", "user_id").EQ(psql.Quote("users", "id"))).
    Where(psql.Quote("users", "created_at").GTE(psql.Arg(time.Now().AddDate(0, -1, 0)))).
    GroupBy(psql.Quote("users", "id")).
    OrderBy(psql.Quote("users", "created_at").Desc())

users, err := bob.All(ctx, db, query, scan.StructMapper[UserSummary]())
if err != nil {
    return nil, err
}

type User struct {
    ID    int    `db:"id"`
    Name  string `db:"name"`
    Email string `db:"email"`
}

func GetUsersPaginated(ctx context.Context, db bob.Executor, page, limit int) ([]User, error) {
    offset := (page - 1) * limit
    
    query := psql.Select("id", "name", "email").
        From("users").
        OrderBy(psql.Quote("id").Asc()).
        Limit(limit).
        Offset(offset)
    
    return bob.All(ctx, db, query, scan.StructMapper[User]())
}