Bool is boolean literal constructor.

Bytea creates new bytea literal expression.

CAST function converts an expr (of any type) into later specified datatype.

Char is a parameter constructor for the PostgreSQL character type.

CONCAT_WS adds two or more expressions together with a separator.

CTE creates new named commonTableExpression.

Date creates new date literal expression.

DATE_TRUNC returns the truncated date and time using optional time zone.

DateT creates new date literal expression from time.Time object.

Double is placeholder constructor for 64-bit float literals.

EXCEPT returns all rows that are in the result of query lhs but not in the result of query rhs.

EXCEPT_ALL returns all rows that are in the result of query lhs but not in the result of query rhs.

EXTRACT function retrieves subfields such as year or hour from date/time values EXTRACT(DAY, User.CreatedAt).

FOLLOWING window frame clause.

FORMAT formats a number to a format like "#,###,###.##", rounded to a specified number of decimal places, then it returns the result as a string.

GENERATE_SERIES generates a series of values from start to stop, with a step size of step.

Int16 is constructor for 16 bit signed integer expressions literals.

Int32 is constructor for 32 bit signed integer expressions literals.

Int64 is constructor for 64 bit signed integer expressions literals.

Int8 is constructor for 8 bit signed integer expressions literals.

INTERSECT returns all rows that are in query results.

INTERSECT_ALL returns all rows that are in query results.

INTERVAL creates new interval expression from the list of quantity-unit pairs.

IntervalColumn creates named interval column.

INTERVALd creates interval expression from time.Duration.

IntervalExp is interval expression wrapper around arbitrary expression.

Json creates new json literal expression.

LATERAL derived tables constructor from select statement.

LOCK creates LockStatement from list of tables.

LOWER_BOUND returns range expressions lower bound.

NewTable creates new table with schema Name, table Name and list of columns.

PERCENTILE_CONT computes a value corresponding to the specified fraction within the ordered set of aggregated argument values.

PERCENTILE_DISC computes the first value within the ordered set of aggregated argument values whose position in the ordering equals or exceeds the specified fraction.

PRECEDING window frame clause.

RawStatement creates new sql statements from raw query and optional map of named arguments.

Real is placeholder constructor for 32-bit float literals.

ROW function is used to create a tuple value that consists of a set of expressions or column values.

SELECT creates new SelectStatement with list of projections.

SET creates conflict action for ON_CONFLICT clause.

String is a parameter constructor for the PostgreSQL text type.

Text is a parameter constructor for the PostgreSQL text type.

Time creates new time literal expression.

Timestamp creates new timestamp literal expression.

TimestampT creates new timestamp literal expression from time.Time object.

Timestampz creates new timestamp with time zone literal expression.

TimestampzT creates new timestamp literal expression from time.Time object.

TimeT creates new time literal expression from time.Time object.

Timez creates new time with time zone literal expression.

TimezT creates new time with time zone literal expression from time.Time object.

Uint16 is constructor for 16 bit unsigned integer expressions literals.

Uint32 is constructor for 32 bit unsigned integer expressions literals.

Uint8 is constructor for 8 bit unsigned integer expressions literals.

UNION effectively appends the result of sub-queries(select statements) into single query.

UNION_ALL effectively appends the result of sub-queries(select statements) into single query.

UPPER_BOUND returns range expressions upper bound.

VALUES is a table value constructor that computes a set of one or more rows as a temporary constant table.

VarChar is a parameter constructor for the PostgreSQL character varying type.

WITH function creates new WITH statement from list of common table expressions.

WITH_RECURSIVE function creates new WITH RECURSIVE statement from list of common table expressions.

WRAP surrounds a list of expressions or columns with parentheses, producing new row: (expression1, expression2, ...) The construct (a, b) is normally recognized in expressions as a row constructor.

Interval unit types.

Interval unit types.

Interval unit types.

DEFAULT is jet equivalent of SQL DEFAULT.

Additional time unit types for EXTRACT function.

Additional time unit types for EXTRACT function.

Additional time unit types for EXTRACT function.

Interval unit types.

Additional time unit types for EXTRACT function.

Additional time unit types for EXTRACT function.

Additional time unit types for EXTRACT function.

Lock types for LockStatement.

Lock types for LockStatement.

Lock types for LockStatement.

Lock types for LockStatement.

Lock types for LockStatement.

Lock types for LockStatement.

Lock types for LockStatement.

Lock types for LockStatement.

Interval unit types.

Interval unit types.

Interval unit types.

Interval unit types.

Interval unit types.

Additional time unit types for EXTRACT function.

Interval unit types.

Additional time unit types for EXTRACT function.

Additional time unit types for EXTRACT function.

Additional time unit types for EXTRACT function.

Interval unit types.

Interval unit types.

ABSf calculates absolute value from float expression.

ABSi calculates absolute value from int expression.

AND function adds AND operator between expressions.

AVG is aggregate function used to calculate avg value from numeric expression.

BinaryOperator can be used to use custom or unsupported operators that take two operands.

BIT_AND is aggregate function used to calculates the bitwise AND of all non-null input values, or null if none.

BIT_LENGTH returns number of bits in string expression.

BIT_NOT inverts every bit in integer expression result.

BIT_OR is aggregate function used to calculates the bitwise OR of all non-null input values, or null if none.

BOOL_AND is aggregate function.

BOOL_OR is aggregate function.

BoolColumn creates named bool column.

BoolExp is bool expression wrapper around arbitrary expression.

BTRIM removes the longest string consisting only of characters in characters (a space by default) from the start and end of string.

CASE create CASE operator with optional list of expressions.

CBRT calculates cube root of numeric expression.

CEIL calculates ceil of float expression.

CHAR_LENGTH returns number of characters in string expression.

CHR returns character with the given code.

COALESCE function returns the first of its arguments that is not null.

CONCAT adds two or more expressions together.

CONVERT converts string to dest_encoding.

CONVERT_FROM converts string to the database encoding.

CONVERT_TO converts string to dest_encoding.

COUNT is aggregate function.

CUBE operator is used with the GROUP BY clause to generate subtotals for all possible combinations of a group of columns.

CUME_DIST calculates cumulative distribution: (number of partition rows preceding or peer with current row) / total partition rows.

CURRENT_DATE returns current date.

Window function clauses.

CURRENT_TIME returns current time with time zone.

CURRENT_TIMESTAMP returns current timestamp with time zone.

CustomExpression is used to define custom expressions.

DATE_RANGE constructor function to create a date range.

DateColumn creates named date column.

DateExp is date expression wrapper around arbitrary expression.

DateRangeColumn creates named range with range column.

RangeExp is range expression wrapper around arbitrary expression.

Decimal creates new float literal expression.

DECODE decodes binary data from textual representation in string.

DENSE_RANK returns rank of the current row without gaps; this function counts peer groups.

Dialect is implementation of postgres dialect for SQL Builder serialisation.

DISTINCT operator can be used to return distinct values of expr.

ENCODE encodes binary data into a textual representation.

EVERY is aggregate function.

EXISTS checks for existence of the rows in subQuery.

FIRST_VALUE returns value evaluated at the row that is the first row of the window frame.

Float creates new float literal expression.

FloatColumn creates named float column.

FloatExp is date expression wrapper around arbitrary expression.

FLOOR calculates floor of float expression.

Func can be used to call custom or unsupported database functions.

GREATEST selects the largest value from a list of expressions.

GROUPING function is used to identify which columns are included in a grouping set or a subtotal row.

GROUPING_SETS operator allows grouping of the rows in a table by multiple sets of columns(or expressions) in a single query.

INITCAP converts the first letter of each word to upper case and the rest to lower case.

Int is constructor for 64 bit signed integer expressions literals.

INT4_RANGE constructor function to create a int4 range.

Int4RangeColumn creates named range with range column.

RangeExp is range expression wrapper around arbitrary expression.

INT8_RANGE constructor function to create a int8 range.

Int8RangeColumn creates named range with range column.

RangeExp is range expression wrapper around arbitrary expression.

IntegerColumn creates named integer column.

IntExp is int expression wrapper around arbitrary expression.

Row lock types.

LAG returns value evaluated at the row that is offset rows before the current row within the partition; if there is no such row, instead return default (which must be of the same type as value).

LAST_VALUE returns value evaluated at the row that is the last row of the window frame.

LEAD returns value evaluated at the row that is offset rows after the current row within the partition; if there is no such row, instead return default (which must be of the same type as value).

LEAST selects the smallest value from a list of expressions.

LEFT returns first n characters in the string.

LENGTH returns number of characters in string with a given encoding.

LN calculates natural algorithm of float expression.

LOCALTIME returns local time of day using optional precision.

LOCALTIMESTAMP returns current date and time using optional precision.

LOG calculates logarithm of float expression.

LOWER returns string expression in lower case.

LPAD fills up the string to length length by prepending the characters fill (a space by default).

LTRIM removes the longest string containing only characters from characters (a space by default) from the start of string.

MAX is aggregate function.

MAXf is aggregate function.

MAXi is aggregate function.

MD5 calculates the MD5 hash of string, returning the result in hexadecimal.

MIN is aggregate function.

MINf is aggregate function.

MINi is aggregate function.

MINUS_INFINITY is jet equivalent for sql -infinity.

MODE computes the most frequent value of the aggregated argument.

NewEnumValue creates new named enum value.

Row lock types.

NOT returns negation of bool expression result.

NOW returns current date and time.

NTH_VALUE returns value evaluated at the row that is the nth row of the window frame (counting from 1); null if no such row.

NTILE returns integer ranging from 1 to the argument value, dividing the partition as equally as possible.

NULL is jet equivalent of SQL NULL.

NULLIF function returns a null value if value1 equals value2; otherwise it returns value1.

NUM_RANGE constructor function to create a numeric range.

NumericRangeColumn creates named range with range column.

RangeExp is range expression wrapper around arbitrary expression.

OCTET_LENGTH returns number of bytes in string expression.

OR function adds OR operator between expressions.

Window function clauses.

Window function clauses.

PERCENT_RANK calculates relative rank of the current row: (rank - 1) / (total partition rows - 1).

PLUS_INFINITY is jet equivalent for sql infinity.

POW calculates power of base with exponent.

POWER calculates power of base with exponent.

RANK of the current row with gaps; same as row_number of its first peer.

Raw can be used for any unsupported functions, operators or expressions.

Raw can be used for any unsupported functions, operators or expressions.

Raw can be used for any unsupported functions, operators or expressions.

Raw can be used for any unsupported functions, operators or expressions.

Raw can be used for any unsupported functions, operators or expressions.

Raw can be used for any unsupported functions, operators or expressions.

Raw can be used for any unsupported functions, operators or expressions.

Raw can be used for any unsupported functions, operators or expressions.

Raw can be used for any unsupported functions, operators or expressions.

Raw can be used for any unsupported functions, operators or expressions.

Raw can be used for any unsupported functions, operators or expressions.

Raw can be used for any unsupported functions, operators or expressions.

Raw can be used for any unsupported functions, operators or expressions.

Raw can be used for any unsupported functions, operators or expressions.

Raw can be used for any unsupported functions, operators or expressions.

Raw can be used for any unsupported functions, operators or expressions.

REPEAT repeats string the specified number of times.

REPLACE replaces all occurrences in string of substring from with substring to.

REVERSE returns reversed string.

RIGHT returns last n characters in the string.

ROLLUP operator is used with the GROUP BY clause to generate all prefixes of a group of columns including the empty list.

ROUND calculates round of a float expressions with optional precision.

ROW_NUMBER returns number of the current row within its partition, counting from 1.

RowExp serves as a wrapper for an arbitrary expression, treating it as a row expression.

RPAD fills up the string to length length by appending the characters fill (a space by default).

RTRIM removes the longest string containing only characters from characters (a space by default) from the end of string.

SetLogger sets automatic statement logging function Deprecated: use SetQueryLogger instead.

SetQueryLogger sets automatic query logging function.

Row lock types.

SIGN returns sign of float expression.

SQRT calculates square root of numeric expression.

STAR is jet equivalent of SQL *.

StringColumn creates named string column.

StringExp is string expression wrapper around arbitrary expression.

STRPOS returns location of specified substring (same as position(substring in string), but note the reversed argument order).

SUBSTR extracts substring.

SUM is aggregate function.

SUMf is aggregate function.

SUMi is aggregate function.

TimeColumn creates named time column.

TimeExp is time expression wrapper around arbitrary expression.

TimestampColumn creates named timestamp column.

TimestampExp is timestamp expression wrapper around arbitrary expression.

TimestampRangeColumn creates named range with range column.

TimestampzColumn creates named timestamp with time zone column.

TimestampzExp is timestamp with time zone expression wrapper around arbitrary expression.

TimestampzRangeColumn creates named range with range column.

TimezColumn creates named time with time zone column.

TimezExp is time with time zone expression wrapper around arbitrary expression.

TO_ASCII convert string to ASCII from another encoding.

TO_CHAR converts expression to string with format.

TO_DATE converts string to date using format.

TO_HEX converts number to its equivalent hexadecimal representation.

TO_NUMBER converts string to numeric using format.

TO_TIMESTAMP converts string to time stamp with time zone using format.

TRUNC calculates trunc of float expression with optional precision.

TS_RANGE constructor function to create a timestamp range.

RangeExp is range expression wrapper around arbitrary expression.

TSTZ_RANGE constructor function to create a timestampz range.

RangeExp is range expression wrapper around arbitrary expression.

Window function clauses.

Row lock types.

UPPER returns string expression in upper case.

UUID is a helper function to create string literal expression from uuid object value can be any uuid type with a String method.

Window definition reference.

ColumnInterval is interface of PostgreSQL interval columns.

CommonTableExpression defines set of interface methods for postgres CTEs.

DeleteStatement is interface for PostgreSQL DELETE statement.

InsertStatement is interface for SQL INSERT statements.

IntervalExpression is representation of postgres INTERVAL.

LockStatement is interface for MySQL LOCK tables.

ReadableTable interface.

SelectStatement is interface for PostgreSQL SELECT statement.

SelectTable is interface for postgres temporary tables like sub-queries, VALUES, CTEs etc...

Table is interface for MySQL tables.

UpdateStatement is interface of SQL UPDATE statement.

WritableTable interface.

BoolExpression interface.

Column is common column interface for all types of columns.

ColumnAssigment is interface wrapper around column assigment.

ColumnBool is interface for SQL boolean columns.

ColumnDate is interface of SQL date columns.

ColumnFloat is interface for SQL real, numeric, decimal or double precision column.

ColumnInteger is interface for SQL smallint, integer, bigint columns.

ColumnList function returns list of columns that be used as projection or column list for UPDATE and INSERT statement.

ColumnString is interface for SQL text, character, character varying bytea, uuid columns and enums types.

ColumnTime is interface for SQL time column.

ColumnTimestamp is interface of SQL timestamp columns.

ColumnTimestampz is interface of SQL timestamp with timezone columns.

ColumnTimez is interface of SQL time with time zone columns.

DateExpression is interface for date types.

Expression is common interface for all expressions.

FloatExpression is interface.

GroupByClause interface to use as input for GROUP_BY.

IntegerExpression interface.

NumericExpression interface.

OrderByClause is the combination of an expression and the wanted ordering to use as input for ORDER BY.

PrintableStatement is a statement which sql query can be logged.

Projection is interface for all projection types.

ProjectionList can be used to create conditional constructed projection list.

QueryInfo contains information about executed query.

RawArgs is type used to pass optional arguments to Raw method.

RowExpression interface.

RowLock is interface for SELECT statement row lock types.

Rows wraps sql.Rows type with a support for query result mapping.

Statement is common interface for all statements(SELECT, INSERT, UPDATE, DELETE, LOCK).

StringExpression interface.

TableLockMode is a type of possible SQL table lock.

TimeExpression interface.

TimestampExpression interface.

TimestampzExpression interface.

TimezExpression interface for 'time with time zone' types.

Token is used to define custom token in a custom expression.