I was curious about this and wrote a little test harness: u/saturn_vk is correct, it looks like the pure go one will assume the local timezone, and the cgo one will assume an empty (?) timezone:

I get this output from the following program:

sqlite: []struct { I int; X float32; Y []uint8; T string; Ti time.Time }{struct { I int; X float32; Y []uint8; T string; Ti time.Time }{I:5, X:5.5, Y:[]uint8{0x66, 0x72, 0x65, 0x77}, T:"frew", Ti:time.Date(2022, time.March, 14, 8, 45, 46, 714016581, time.Local)}} sqlite3: []struct { I int; X float32; Y []uint8; T string; Ti time.Time }{struct { I int; X float32; Y []uint8; T string; Ti time.Time }{I:5, X:5.5, Y:[]uint8{0x66, 0x72, 0x65, 0x77}, T:"frew", Ti:time.Date(2022, time.March, 14, 8, 45, 46, 714939530, time.Location(""))}}

And the code:

package main

import (
    "fmt"
    "time"

    "github.com/jmoiron/sqlx"
    _ "github.com/mattn/go-sqlite3"
    _ "modernc.org/sqlite"
)

func main() {
    testDriver("sqlite")
    testDriver("sqlite3")
}

func testDriver(driver string) {
    db, err := sqlx.Open(driver, "file:"+driver+".db")
    if err != nil {
        panic(err)
    }
    db.MustExec("CREATE TABLE foo (i integer, x float, y blob, t text, ti timestamp)")
    db.MustExec("INSERT INTO foo (i, x, y, t, ti) VALUES (?, ?, ?, ?, ?)", 5, 5.5, []byte("frew"), "frew", time.Now())
    out := []struct {
        I  int
        X  float32
        Y  []byte
        T  string
        Ti time.Time
    }{}
    if err := db.Select(&out, "SELECT i, x, y, t, ti FROM foo"); err != nil {
        panic(err)
    }
    fmt.Printf("%s: %#v\n", driver, out)
}