go-zetasqlite

A database driver library that interprets ZetaSQL queries and runs them using SQLite3

Features

go-zetasqlite supports database/sql driver interface. So, you can use ZetaSQL queries just by importing github.com/goccy/go-zetasqlite. Also, go-zetasqlite uses SQLite3 as the database engine. Since we are using go-sqlite3, we can use the options ( like :memory: ) supported by go-sqlite3 ( see details ). ZetaSQL functionality is provided by go-zetasql

Installation

go get github.com/goccy/go-zetasqlite

NOTE

Since this library uses go-zetasql, the following environment variables must be enabled in order to build. See here for details.

CGO_ENABLED=1
CXX=clang++

Synopsis

You can pass ZetaSQL queries to Query/Exec function of database/sql package.

package main

import (
  "database/sql"
  "fmt"

  _ "github.com/goccy/go-zetasqlite"
)

func main() {
  db, err := sql.Open("zetasqlite", ":memory:")
  if err != nil {
    panic(err)
  }
  defer db.Close()

  rows, err := db.Query(`SELECT * FROM UNNEST([?, ?, ?])`, 1, 2, 3)
  if err != nil {
    panic(err)
  }
  var ids []int64
  for rows.Next() {
    var id int64
    if err := rows.Scan(&id); err != nil {
      panic(err)
    }
    ids = append(ids, id)
  }
  fmt.Println(ids) // [1 2 3]
}

Tools

ZetaSQLite CLI

You can execute ZetaSQL queries interactively by using the tools provided by cmd/zetasqlite-cli. See here for details

Status

A list of ZetaSQL ( Google Standard SQL ) specifications and features supported by go-zetasqlite.

Types

Expressions

Operators

Conditional Expressions

Subqueries

Query

Statements

DDL ( Data Definition Language )

DML ( Data Manipulation Language )

DCL ( Data Control Language )

GRANT
REVOKE

Procedural Language

Debugging Statements

ASSERT

Other Statements

EXPORT DATA
LOAD DATA

User Defined Functions

User Defined Function
Templated Argument Function
- If the return type is not specified, templated argument function supports only some types of patterns.
  - ANY -> ANY
  - ARRAY<ANY> -> ANY
  - ANY -> ARRAY<ANY>
  - If the return type is always fixed, only some types are supported, such as INT64 / DOUBLE
JavaScript UDF

Functions

Aggregate functions

Statistical aggregate functions

Approximate aggregate functions

APPROX_COUNT_DISTINCT
APPROX_QUANTILES
APPROX_TOP_COUNT
APPROX_TOP_SUM

HyperLogLog++ functions

HLL_COUNT.INIT
HLL_COUNT.MERGE
HLL_COUNT.MERGE_PARTIAL
HLL_COUNT.EXTRACT

Numbering functions

Bit functions

BIT_COUNT

Conversion functions

Mathematical functions

Navigation functions

Hash functions

String functions

JSON functions

Array functions

Date functions

Datetime functions

Time functions

Timestamp functions

Interval functions

Geography functions

Security functions

SESSION_USER

UUID functions

GENERATE_UUID

Net functions

Debugging functions

ERROR

AEAD encryption functions

License

MIT

marcellustavares/go-zetasqlite