prorm API Reference
    Preparing search index...

    Module query-builders/functions

    StringAggOptions
    ArrayAggOptions
    DateTimeExpression
    FullTextMatchOptions
    JsonExtractOptions
    TrimOptions
    WindowFrame
    SqlExpr
    AggOrderBy
    CaseValue
    CaseCondition
    DateTimeArg
    DateTruncUnit
    DateAddUnit
    DateDiffUnit
    FullTextMatchMode
    FullTextColumns
    JsonExprArg
    MathSqlExpr
    StringSqlExpr
    WindowDialect
    WindowOrderDirection
    WindowNulls
    WindowFrameBoundary
    WindowArg
    count → count
    countDistinct → countDistinct
    sum → sqlSum
    avg → avg
    min → min
    max → max
    stringAgg → stringAgg
    arrayAgg → arrayAgg
    CaseBuilder → CaseBuilder
    SimpleCaseBuilder → SimpleCaseBuilder
    caseWhen → caseWhen
    caseOf → caseOf
    dateTrunc → dateTrunc
    dateAdd → dateAdd
    dateSub → dateSub
    dateDiff → dateDiff
    now → sqlNow
    currentDate → currentDate
    currentTimestamp → currentTimestamp
    formatDate → sqlFormatDate
    fullTextMatch → fullTextMatch
    fullTextRank → fullTextRank
    jsonExtract → jsonExtract
    jsonContains → sqlJsonContains
    jsonHasKey → sqlJsonHasKey
    jsonKeys → jsonKeys
    jsonTypeOf → jsonTypeOf
    round → round
    ceil → ceil
    floor → floor
    power → power
    sqrt → sqrt
    abs → abs
    sign → sign
    mod → mod
    random → sqlRandom
    greatest → greatest
    least → least
    truncate → sqlTruncate
    concat → concat
    substring → sqlSubstring
    trim → sqlTrim
    ltrim → sqlLtrim
    rtrim → sqlRtrim
    upper → upper
    lower → lower
    length → length
    replace → replace
    lpad → lpad
    rpad → rpad
    split → split
    repeat → sqlRepeat
    reverse → sqlReverse
    WindowFunctionBuilder → WindowFunctionBuilder
    rowNumber → rowNumber
    rank → rank
    denseRank → denseRank
    percentRank → percentRank
    cumeDist → cumeDist
    ntile → ntile
    lag → lag
    lead → lead
    firstValue → firstValue
    lastValue → lastValue
    nthValue → nthValue
    sumOver → sumOver
    avgOver → avgOver
    countOver → countOver
    minOver → minOver
    maxOver → maxOver
    windowFn → windowFn
    NullsOrder → NullsOrder

    Settings
    Member Visibility

    On This Page
    Interfaces
    Type Aliases
    References