mkdir sqlite3auth
cd sqlite3auth
go mod init sqlite3auth
touch main.go

package main
import (
        "database/sql"
        "log"
        "github.com/mattn/go-sqlite3"
)
func main() {
        // This is not necessary; just to see if auth extension is enabled
        sql.Register("sqlite3_log", &sqlite3.SQLiteDriver{
                ConnectHook: func(conn *sqlite3.SQLiteConn) error {
                        log.Printf("Auth enabled: %v\n", conn.AuthEnabled())
                        return nil
                },
        })
        // This is usual DB stuff (except with our sqlite3_log driver)
        db, err := sql.Open("sqlite3_log", "file:test.db?_auth&_auth_user=admin&_auth_pass=admin")
        if err != nil {
                log.Fatal(err)
        }
        defer db.Close()
        _, err = db.Exec(`select 1`)
        if err != nil {
                log.Fatal(err)
        }
}

go mod tidy
go: finding module for package github.com/mattn/go-sqlite3
go: found github.com/mattn/go-sqlite3 in github.com/mattn/go-sqlite3 v1.14.10
# First build with auth extension (-o NAME is just to give binary a name)
go build -tags sqlite_userauth -o auth .
# then build without it
go build -o noauth .
./auth
2022/01/27 21:47:46 Auth enabled: true
./noauth
2022/01/27 21:47:46 Auth enabled: false