duckdbsql

Documentation

Index

• func EscapeStringValue(s string) string
• func EvaluateBool(expr string) (bool, error)
• type AST
  • func Parse(sql string) (*AST, error)
  • func (a *AST) ExtractColumnRefs() []*ColumnRef
  • func (a *AST) Format() (string, error)
  • func (a *AST) GetTableRefs() []*TableRef
  • func (a *AST) RewriteLimit(limit, offset int) error
  • func (a *AST) RewriteTableRefs(fn func(table *TableRef) (*TableRef, bool)) error
• type ColumnRef
• type PositionError
  • func (e PositionError) Err() error
• type TableRef

Functions

func EscapeStringValue

func EscapeStringValue(s string) string

EscapeStringValue escapes a string value for use in an expression passed to EvaluateBool.

func EvaluateBool

func EvaluateBool(expr string) (bool, error)

EvaluateBool uses DuckDB to evaluate the given expression as a boolean value.

Types

type AST

type AST struct {
	// contains filtered or unexported fields
}

func Parse

func Parse(sql string) (*AST, error)

func (*AST) ExtractColumnRefs

func (a *AST) ExtractColumnRefs() []*ColumnRef

ExtractColumnRefs extracts column references from the outermost SELECT of a DuckDB SQL statement

func (*AST) Format

func (a *AST) Format() (string, error)

Format normalizes a DuckDB SQL statement

func (*AST) GetTableRefs

func (a *AST) GetTableRefs() []*TableRef

func (*AST) RewriteLimit

func (a *AST) RewriteLimit(limit, offset int) error

RewriteLimit rewrites a DuckDB SQL statement to limit the result size

func (*AST) RewriteTableRefs

func (a *AST) RewriteTableRefs(fn func(table *TableRef) (*TableRef, bool)) error

RewriteTableRefs replaces table references in a DuckDB SQL query. Only replacing with a base table reference is supported right now.

type ColumnRef

type ColumnRef struct {
	Name         string
	RelationName string
	Expr         string
	IsAggr       bool
	IsStar       bool
	IsExclude    bool
}

ColumnRef has information about a column in the select list of a DuckDB SQL statement

type PositionError

type PositionError struct {
	Position int
	// contains filtered or unexported fields
}

func (PositionError) Err

func (e PositionError) Err() error

type TableRef

type TableRef struct {
	Name       string
	Function   string
	Paths      []string
	Properties map[string]any
	LocalAlias bool
	// Params passed to sqlite_scan
	Params []string
}

TableRef has information extracted about a DuckDB table or table function reference