Versions in this module Expand all Collapse all v0 v0.1.0 Apr 15, 2025 Changes in this version + const CENTURY + const DAY + const DECADE + const DEFAULT + const DOW + const DOY + const EPOCH + const HOUR + const ISODOW + const ISOYEAR + const JULIAN + const MICROSECOND + const MILLENNIUM + const MILLISECOND + const MINUTE + const MONTH + const QUARTER + const SECOND + const TIMEZONE + const TIMEZONE_HOUR + const TIMEZONE_MINUTE + const WEEK + const YEAR + var ABSf = jet.ABSf + var ABSi = jet.ABSi + var AND = jet.AND + var AVG = jet.AVG + var BIT_AND = jet.BIT_AND + var BIT_COUNT = jet.BIT_COUNT + var BIT_LENGTH = jet.BIT_LENGTH + var BIT_NOT = jet.BIT_NOT + var BIT_OR = jet.BIT_OR + var BOOL_AND = jet.BOOL_AND + var BOOL_OR = jet.BOOL_OR + var BTRIM = jet.BTRIM + var Base64 = StringExp(jet.FixedLiteral("base64")) + var BinaryOperator = jet.BinaryOperator + var BoolArrayColumn = jet.ArrayColumn[BoolExpression] + var BoolColumn = jet.BoolColumn + var BoolExp = jet.BoolExp + var ByteaColumn = jet.BlobColumn + var ByteaExp = jet.BlobExp + var CASE = jet.CASE + var CBRT = jet.CBRT + var CEIL = jet.CEIL + var CHAR_LENGTH = jet.CHAR_LENGTH + var CHR = jet.CHR + var COALESCE = jet.COALESCE + var CONCAT = func(expressions ...Expression) StringExpression + var CONVERT_FROM = jet.CONVERT_FROM + var CONVERT_TO = jet.CONVERT_TO + var COUNT = jet.COUNT + var CUBE = jet.CUBE + var CUME_DIST = jet.CUME_DIST + var CURRENT_DATE = jet.CURRENT_DATE + var CURRENT_ROW = jet.CURRENT_ROW + var CURRENT_TIME = jet.CURRENT_TIME + var CURRENT_TIMESTAMP = jet.CURRENT_TIMESTAMP + var CustomExpression = jet.CustomExpression + var DATE_RANGE = jet.DateRange + var DECODE = jet.DECODE + var DENSE_RANK = jet.DENSE_RANK + var DISTINCT = jet.DISTINCT + var DateColumn = jet.DateColumn + var DateExp = jet.DateExp + var DateRangeColumn = jet.RangeColumn[DateExpression] + var DateRangeExp = jet.DateRangeExp + var Decimal = jet.Decimal + var Dialect = newDialect() + var ENCODE = jet.ENCODE + var EVERY = jet.EVERY + var EXISTS = jet.EXISTS + var Escape = StringExp(jet.FixedLiteral("escape")) + var FIRST_VALUE = jet.FIRST_VALUE + var FLOOR = jet.FLOOR + var Float = jet.Float + var FloatColumn = jet.FloatColumn + var FloatExp = jet.FloatExp + var Func = jet.Func + var GREATEST = jet.GREATEST + var GROUPING = jet.GROUPING + var GROUPING_SETS = jet.GROUPING_SETS + var Hex = StringExp(jet.FixedLiteral("hex")) + var INITCAP = jet.INITCAP + var INT4_RANGE = jet.Int4Range + var INT8_RANGE = jet.Int8Range + var ISO_8859_5 = StringExp(jet.FixedLiteral("ISO_8859_5")) + var ISO_8859_6 = StringExp(jet.FixedLiteral("ISO_8859_6")) + var ISO_8859_7 = StringExp(jet.FixedLiteral("ISO_8859_7")) + var ISO_8859_8 = StringExp(jet.FixedLiteral("ISO_8859_8")) + var Int = jet.Int + var Int4RangeColumn = jet.RangeColumn[jet.Int4Expression] + var Int4RangeExp = jet.Int4RangeExp + var Int8RangeColumn = jet.RangeColumn[jet.Int8Expression] + var Int8RangeExp = jet.Int8RangeExp + var IntExp = jet.IntExp + var IntegerArrayColumn = jet.ArrayColumn[IntegerExpression] + var IntegerColumn = jet.IntegerColumn + var IntervalColumn = jet.IntervalColumn + var IntervalExp = jet.IntervalExp + var KEY_SHARE = jet.NewRowLock("KEY SHARE") + var KOI8R = StringExp(jet.FixedLiteral("KOI8R")) + var KOI8U = StringExp(jet.FixedLiteral("KOI8U")) + var LAG = jet.LAG + var LAST_VALUE = jet.LAST_VALUE + var LATIN1 = StringExp(jet.FixedLiteral("LATIN1")) + var LATIN2 = StringExp(jet.FixedLiteral("LATIN2")) + var LATIN3 = StringExp(jet.FixedLiteral("LATIN3")) + var LATIN4 = StringExp(jet.FixedLiteral("LATIN4")) + var LEAD = jet.LEAD + var LEAST = jet.LEAST + var LEFT = jet.LEFT + var LENGTH = jet.LENGTH + var LN = jet.LN + var LOCALTIME = jet.LOCALTIME + var LOCALTIMESTAMP = jet.LOCALTIMESTAMP + var LOG = jet.LOG + var LOWER = jet.LOWER + var LPAD = jet.LPAD + var LTRIM = jet.LTRIM + var MAX = jet.MAX + var MAXf = jet.MAXf + var MAXi = jet.MAXi + var MD5 = jet.MD5 + var MIN = jet.MIN + var MINUS_INFINITY = jet.MINUS_INFINITY + var MINf = jet.MINf + var MINi = jet.MINi + var MODE = jet.MODE + var NOT = jet.NOT + var NOW = jet.NOW + var NO_KEY_UPDATE = jet.NewRowLock("NO KEY UPDATE") + var NTH_VALUE = jet.NTH_VALUE + var NTILE = jet.NTILE + var NULL = jet.NULL + var NULLIF = jet.NULLIF + var NUM_RANGE = jet.NumRange + var NewEnumValue = jet.NewEnumValue + var NumRangeExp = jet.NumRangeExp + var NumericRangeColumn = jet.RangeColumn[NumericExpression] + var OCTET_LENGTH = jet.OCTET_LENGTH + var OR = jet.OR + var ORDER_BY = jet.ORDER_BY + var PARTITION_BY = jet.PARTITION_BY + var PERCENT_RANK = jet.PERCENT_RANK + var PLUS_INFINITY = jet.PLUS_INFINITY + var POW = jet.POW + var POWER = jet.POWER + var RANK = jet.RANK + var REPEAT = jet.REPEAT + var REPLACE = jet.REPLACE + var REVERSE = jet.REVERSE + var RIGHT = jet.RIGHT + var ROLLUP = jet.ROLLUP + var ROUND = jet.ROUND + var ROW_NUMBER = jet.ROW_NUMBER + var RPAD = jet.RPAD + var RTRIM = jet.RTRIM + var Raw = jet.Raw + var RawBool = jet.RawBool + var RawBytea = jet.RawBlob + var RawDate = jet.RawDate + var RawDateRange = jet.RawRange[jet.DateExpression] + var RawFloat = jet.RawFloat + var RawInt = jet.RawInt + var RawInt4Range = jet.RawRange[jet.Int4Expression] + var RawInt8Range = jet.RawRange[jet.Int8Expression] + var RawNumRange = jet.RawRange[jet.NumericExpression] + var RawString = jet.RawString + var RawTime = jet.RawTime + var RawTimestamp = jet.RawTimestamp + var RawTimestampRange = jet.RawRange[jet.TimestampExpression] + var RawTimestampz = jet.RawTimestampz + var RawTimestampzRange = jet.RawRange[jet.TimestampzExpression] + var RawTimez = jet.RawTimez + var RowExp = jet.RowExp + var SHARE = jet.NewRowLock("SHARE") + var SIGN = jet.SIGN + var SQRT = jet.SQRT + var STAR = jet.STAR + var STRPOS = jet.STRPOS + var SUBSTR = jet.SUBSTR + var SUM = jet.SUM + var SUMf = jet.SUMf + var SUMi = jet.SUMi + var SetLogger = jet.SetLoggerFunc + var SetQueryLogger = jet.SetQueryLogger + var StringArrayColumn = jet.ArrayColumn[StringExpression] + var StringColumn = jet.StringColumn + var StringExp = jet.StringExp + var TO_ASCII = jet.TO_ASCII + var TO_CHAR = jet.TO_CHAR + var TO_DATE = jet.TO_DATE + var TO_HEX = jet.TO_HEX + var TO_NUMBER = jet.TO_NUMBER + var TO_TIMESTAMP = jet.TO_TIMESTAMP + var TRUNC = jet.TRUNC + var TSTZ_RANGE = jet.TstzRange + var TS_RANGE = jet.TsRange + var TimeColumn = jet.TimeColumn + var TimeExp = jet.TimeExp + var TimestampColumn = jet.TimestampColumn + var TimestampExp = jet.TimestampExp + var TimestampRangeColumn = jet.RangeColumn[TimestampExpression] + var TimestampzColumn = jet.TimestampzColumn + var TimestampzExp = jet.TimestampzExp + var TimestampzRangeColumn = jet.RangeColumn[TimestampzExpression] + var TimezColumn = jet.TimezColumn + var TimezExp = jet.TimezExp + var TsRangeExp = jet.TsRangeExp + var TstzRangeExp = jet.TstzRangeExp + var UNBOUNDED = int64(math.MaxInt64) + var UPDATE = jet.NewRowLock("UPDATE") + var UPPER = jet.UPPER + var UTF8 = StringExp(jet.FixedLiteral("UTF8")) + var UUID = jet.UUID + var WIN1252 = StringExp(jet.FixedLiteral("WIN1252")) + var Window = jet.WindowName + func ALL[T Expression](expression jet.Array[T]) T + func ANY[T Expression](expression jet.Array[T]) T + func ARRAY[T Expression](elems ...T) jet.Array[T] + func ARRAY_APPEND[E Expression](arr jet.Array[E], el E) jet.Array[E] + func ARRAY_CAT[E Expression](arr1, arr2 jet.Array[E]) jet.Array[E] + func ARRAY_PREPEND[E Expression](el E, arr jet.Array[E]) jet.Array[E] + func CAST(expr Expression) *cast + func Char(length ...int) func(value string) StringExpression + func EXCEPT(lhs, rhs jet.SerializerStatement) setStatement + func EXCEPT_ALL(lhs, rhs jet.SerializerStatement) setStatement + func FOLLOWING(offset int64) jet.FrameExtent + func INTERSECT(lhs, rhs jet.SerializerStatement, selects ...jet.SerializerStatement) setStatement + func INTERSECT_ALL(lhs, rhs jet.SerializerStatement, selects ...jet.SerializerStatement) setStatement + func LATERAL(selectStmt SelectStatement) lateralImpl + func LOWER_BOUND[T Expression](expression jet.Range[T]) T + func PERCENTILE_CONT(fraction FloatExpression) *jet.OrderSetAggregateFunc + func PERCENTILE_DISC(fraction FloatExpression) *jet.OrderSetAggregateFunc + func PRECEDING(offset int64) jet.FrameExtent + func RawStatement(rawQuery string, namedArguments ...RawArgs) jet.SerializerStatement + func SET(assigments ...ColumnAssigment) conflictAction + func UNION(lhs, rhs jet.SerializerStatement, selects ...jet.SerializerStatement) setStatement + func UNION_ALL(lhs, rhs jet.SerializerStatement, selects ...jet.SerializerStatement) setStatement + func UPPER_BOUND[T Expression](expression jet.Range[T]) T + func VALUES(rows ...RowExpression) values + func VarChar(length ...int) func(value string) StringExpression + func WITH(cte ...CommonTableExpression) func(statement jet.Statement) Statement + func WITH_RECURSIVE(cte ...CommonTableExpression) func(statement jet.Statement) Statement + type BoolArrayExpression = jet.Array[BoolExpression] + func BoolArray(elements []bool) BoolArrayExpression + type BoolExpression = jet.BoolExpression + func Bool(value bool) BoolExpression + type ByteaExpression = jet.BlobExpression + func Bytea(value interface{}) ByteaExpression + func CONVERT(str ByteaExpression, srcEncoding StringExpression, ...) ByteaExpression + func SET_BIT(bytes ByteaExpression, n IntegerExpression, newValue IntegerExpression) ByteaExpression + func SET_BYTE(bytes ByteaExpression, n IntegerExpression, newValue IntegerExpression) ByteaExpression + func SHA224(bytes ByteaExpression) ByteaExpression + func SHA256(bytes ByteaExpression) ByteaExpression + func SHA384(bytes ByteaExpression) ByteaExpression + func SHA512(bytes ByteaExpression) ByteaExpression + type Column = jet.ColumnExpression + type ColumnAssigment = jet.ColumnAssigment + type ColumnBool = jet.ColumnBool + type ColumnBoolArray jet.ColumnArray[BoolExpression] + type ColumnBytea = jet.ColumnBlob + type ColumnDate = jet.ColumnDate + type ColumnDateRange = jet.ColumnRange[DateExpression] + type ColumnFloat = jet.ColumnFloat + type ColumnInt4Range jet.ColumnRange[jet.Int4Expression] + type ColumnInt8Range jet.ColumnRange[jet.Int8Expression] + type ColumnInteger = jet.ColumnInteger + type ColumnIntegerArray jet.ColumnArray[IntegerExpression] + type ColumnInterval = jet.ColumnInterval + type ColumnList = jet.ColumnList + type ColumnNumericRange = jet.ColumnRange[NumericExpression] + type ColumnString = jet.ColumnString + type ColumnStringArray jet.ColumnArray[StringExpression] + type ColumnTime = jet.ColumnTime + type ColumnTimestamp = jet.ColumnTimestamp + type ColumnTimestampRange = jet.ColumnRange[TimestampExpression] + type ColumnTimestampz = jet.ColumnTimestampz + type ColumnTimestampzRange = jet.ColumnRange[TimestampzExpression] + type ColumnTimez = jet.ColumnTimez + type CommonTableExpression interface + ALIAS func(alias string) SelectTable + AS func(statement jet.SerializerHasProjections) CommonTableExpression + AS_NOT_MATERIALIZED func(statement jet.SerializerStatement) CommonTableExpression + func CTE(name string, columns ...jet.ColumnExpression) CommonTableExpression + type DateExpression = jet.DateExpression + func Date(year int, month time.Month, day int) DateExpression + func DateT(t time.Time) DateExpression + type DateRange = jet.Range[DateExpression] + type DeleteStatement interface + RETURNING func(projections ...jet.Projection) DeleteStatement + USING func(tables ...ReadableTable) DeleteStatement + WHERE func(expression BoolExpression) DeleteStatement + type Expression = jet.Expression + func GENERATE_SERIES(start Expression, stop Expression, step ...Expression) Expression + type FloatExpression = jet.FloatExpression + func Double(value float64) FloatExpression + func EXTRACT(field unit, from Expression) FloatExpression + func Real(value float32) FloatExpression + type GroupByClause = jet.GroupByClause + type InsertStatement interface + MODEL func(data interface{}) InsertStatement + MODELS func(data interface{}) InsertStatement + ON_CONFLICT func(indexExpressions ...jet.ColumnExpression) onConflict + QUERY func(selectStatement SelectStatement) InsertStatement + RETURNING func(projections ...Projection) InsertStatement + VALUES func(value interface{}, values ...interface{}) InsertStatement + type Int4Range = jet.Range[IntegerExpression] + type Int8Range = jet.Range[IntegerExpression] + type IntegerArrayExpression = jet.Array[IntegerExpression] + func Int32Array(elements []int32) IntegerArrayExpression + func Int64Array(elements []int64) IntegerArrayExpression + type IntegerExpression = jet.IntegerExpression + func ARRAY_LENGTH[E Expression](arr jet.Array[E], el IntegerExpression) IntegerExpression + func ARRAY_REMOVE[E Expression](arr jet.Array[E], el Expression) IntegerExpression + func GET_BIT(bytes ByteaExpression, n IntegerExpression) IntegerExpression + func GET_BYTE(bytes ByteaExpression, n IntegerExpression) IntegerExpression + func Int16(value int16) IntegerExpression + func Int32(value int32) IntegerExpression + func Int64(value int64) IntegerExpression + func Int8(value int8) IntegerExpression + func Uint16(value uint16) IntegerExpression + func Uint32(value uint32) IntegerExpression + func Uint64(value uint64) IntegerExpression + func Uint8(value uint8) IntegerExpression + type IntervalExpression = jet.IntervalExpression + func INTERVAL(quantityAndUnit ...quantityAndUnit) IntervalExpression + func INTERVALd(duration time.Duration) IntervalExpression + type LockStatement interface + IN func(lockMode TableLockMode) LockStatement + NOWAIT func() LockStatement + func LOCK(tables ...jet.SerializerTable) LockStatement + type NumericExpression = jet.NumericExpression + type NumericRange = jet.Range[NumericExpression] + type OrderByClause = jet.OrderByClause + type PrintableStatement = jet.PrintableStatement + type Projection = jet.Projection + type ProjectionList = jet.ProjectionList + type QueryInfo = jet.QueryInfo + type RawArgs = map[string]interface + type ReadableTable interface + type RowExpression = jet.RowExpression + func ROW(expressions ...Expression) RowExpression + func WRAP(expressions ...Expression) RowExpression + type RowLock = jet.RowLock + type Rows = jet.Rows + type SelectStatement interface + AsTable func(alias string) SelectTable + DISTINCT func(on ...jet.ColumnExpression) SelectStatement + EXCEPT func(rhs SelectStatement) setStatement + EXCEPT_ALL func(rhs SelectStatement) setStatement + FETCH_FIRST func(count IntegerExpression) fetchExpand + FOR func(lock RowLock) SelectStatement + FROM func(tables ...ReadableTable) SelectStatement + GROUP_BY func(groupByClauses ...GroupByClause) SelectStatement + HAVING func(boolExpression BoolExpression) SelectStatement + INTERSECT func(rhs SelectStatement) setStatement + INTERSECT_ALL func(rhs SelectStatement) setStatement + LIMIT func(limit int64) SelectStatement + OFFSET func(offset int64) SelectStatement + OFFSET_e func(offset IntegerExpression) SelectStatement + ORDER_BY func(orderByClauses ...OrderByClause) SelectStatement + UNION func(rhs SelectStatement) setStatement + UNION_ALL func(rhs SelectStatement) setStatement + WHERE func(expression BoolExpression) SelectStatement + WINDOW func(name string) windowExpand + func SELECT(projection Projection, projections ...Projection) SelectStatement + func SELECT_JSON_ARR(projections ...Projection) SelectStatement + func SELECT_JSON_OBJ(projections ...Projection) SelectStatement + type SelectTable interface + type Statement = jet.Statement + type StringArrayExpression = jet.Array[StringExpression] + func StringArray(elements []string) StringArrayExpression + type StringExpression = jet.StringExpression + func ARRAY_TO_STRING(arr Expression, delim StringExpression) StringExpression + func CONCAT_WS(separator Expression, expressions ...Expression) StringExpression + func FORMAT(formatStr StringExpression, formatArgs ...Expression) StringExpression + func Json(value interface{}) StringExpression + func String(value string) StringExpression + func Text(value string) StringExpression + type Table interface + func NewTable(schemaName, name, alias string, columns ...jet.ColumnExpression) Table + type TableLockMode string + const LOCK_ACCESS_EXCLUSIVE + const LOCK_ACCESS_SHARE + const LOCK_EXCLUSIVE + const LOCK_ROW_EXCLUSIVE + const LOCK_ROW_SHARE + const LOCK_SHARE + const LOCK_SHARE_ROW_EXCLUSIVE + const LOCK_SHARE_UPDATE_EXCLUSIVE + type TimeExpression = jet.TimeExpression + func Time(hour, minute, second int, nanoseconds ...time.Duration) TimeExpression + func TimeT(t time.Time) TimeExpression + type TimestampExpression = jet.TimestampExpression + func DATE_TRUNC(field unit, source Expression, timezone ...string) TimestampExpression + func Timestamp(year int, month time.Month, day, hour, minute, second int, ...) TimestampExpression + func TimestampT(t time.Time) TimestampExpression + type TimestampRange = jet.Range[TimestampExpression] + type TimestampzExpression = jet.TimestampzExpression + func Timestampz(year int, month time.Month, day, hour, minute, second int, ...) TimestampzExpression + func TimestampzT(t time.Time) TimestampzExpression + type TimestampzRange = jet.Range[TimestampzExpression] + type TimezExpression = jet.TimezExpression + func Timez(hour, minute, second int, milliseconds time.Duration, timezone string) TimezExpression + func TimezT(t time.Time) TimezExpression + type Token = jet.Token + type UpdateStatement interface + FROM func(tables ...ReadableTable) UpdateStatement + MODEL func(data interface{}) UpdateStatement + RETURNING func(projections ...Projection) UpdateStatement + SET func(value interface{}, values ...interface{}) UpdateStatement + WHERE func(expression BoolExpression) UpdateStatement + type WritableTable interface
Go to main page