# Functions
CAST function converts a expr (of any type) into latter specified datatype.
CONCAT_WS adds two or more expressions together with a separator.
CTE creates new named CommonTableExpression.
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.
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.
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.
LOCK creates LockStatement from list of tables.
NewTable creates new table with schema Name, table Name and list of columns.
PRECEDING window frame clause.
SELECT creates new SelectStatement with list of projections.
SET creates conflict action for ON_CONFLICT clause.
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.
WITH function creates new WITH statement from list of common table expressions.
# Constants
Interval unit types.
Interval unit types.
Interval unit types.
DEFAULT is jet equivalent of SQL DEFAULT.
Interval unit types.
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.
Interval unit types.
Interval unit types.
Interval unit types.
# Variables
ABSf calculates absolute value from float expression.
ABSi calculates absolute value from int expression.
AVG is aggregate function used to calculate avg value from numeric expression.
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 creates new bool literal expression.
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.
Bytea craates new bytea literal expression.
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.
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.
Date creates new date literal expression.
DateColumn creates named date column.
DateExp is date expression wrapper around arbitrary expression.
DateT creates new date literal expression from time.Time object.
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.
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.
GREATEST selects the largest value from a list of expressions.
INITCAP converts the first letter of each word to upper case and the rest to lower case.
Int creates new integer literal 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.
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.
OCTET_LENGTH returns number of bytes in string expression.
Window function clauses.
Window function clauses.
PERCENT_RANK calculates relative rank of the current row: (rank - 1) / (total partition rows - 1).
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.
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.
ROUND calculates round of a float expressions with optional precision.
ROW is construct one table row from list of expressions.
ROW_NUMBER returns number of the current row within its partition, counting from 1.
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.
Row lock types.
SIGN returns sign of float expression.
SQRT calculates square root of numeric expression.
STAR is jet equivalent of SQL *.
String creates new string literal expression.
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.
Time creates new time literal expression.
TimeColumn creates named time column.
TimeExp is time expression wrapper around arbitrary expression.
Timestamp creates new timestamp literal expression.
TimestampColumn creates named timestamp column.
TimestampExp is timestamp expression wrapper around arbitrary expression.
TimestampT creates new timestamp literal expression from time.Time object.
Timestampz creates new timestamp with time zone literal expression.
TimestampzColumn creates named timestamp with time zone column.
TimestampzExp is timestamp with time zone expression wrapper around arbitrary 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.
TimezColumn creates named time with time zone column.
TimezExp is time with time zone expression wrapper around arbitrary expression.
TimezT creates new time with time zone literal expression from time.Time object.
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.
Window function clauses.
Row lock types.
UPPER returns string expression in upper case.
Window definition reference.
# Structs
CommonTableExpression contains information about a CTE.
# Interfaces
ColumnInterval is interface of PostgreSQL interval columns.
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 MySQL sub-queries.
Table is interface for MySQL tables.
UpdateStatement is interface of SQL UPDATE statement.
WritableTable interface.
# Type aliases
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.
IntegerExpression interface.
NumericExpression interface.
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.
RowLock is interface for SELECT statement row lock types.
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.