statement

package

v0.30.0 Latest Latest Go to latest Published: Nov 5, 2025 License: MIT Imports: 7 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/ncruces/go-sqlite3

Links

Open Source Insights

Documentation ¶

Overview ¶

Package statement defines table-valued functions using SQL.

It can be used to create "parametrized views": pre-packaged queries that can be parametrized at query execution time.

https://github.com/0x09/sqlite-statement-vtab

Example ¶

sqlite3.AutoExtension(statement.Register)

db, err := sqlite3.Open(":memory:")
if err != nil {
	log.Fatal(err)
}
defer db.Close()

err = db.Exec(`
		CREATE VIRTUAL TABLE split_date USING statement((
			SELECT
				strftime('%Y', :date) AS year,
				strftime('%m', :date) AS month,
				strftime('%d', :date) AS day
		))`)
if err != nil {
	log.Fatal(err)
}

stmt, _, err := db.Prepare(`SELECT * FROM split_date('2022-02-22')`)
if err != nil {
	log.Fatal(err)
}
defer stmt.Close()

if stmt.Step() {
	fmt.Printf("Twosday was %d-%d-%d", stmt.ColumnInt(0), stmt.ColumnInt(1), stmt.ColumnInt(2))
}
if err := stmt.Reset(); err != nil {
	log.Fatal(err)
}