# SQLite [Home](/rezoom-sql/master.md) > [Language](/rezoom-sql/language.md) > [Functions](/rezoom-sql/language/functions.md) > SQLite [← Functions](/rezoom-sql/language/functions.md) | [TSQL →](/rezoom-sql/language/functions/tsqlfunctions.md) ## SQLite functions This is the complete list of built-in functions supported by the `"sqlite"` backend. ### abs ``` abs( a^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### avg ``` avg( a) -> FLOAT64? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### changes ``` changes() -> INT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### char ``` char(STRING{0..*}) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### coalesce ``` coalesce(a?, a?{0..*}, a^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### count ``` count() -> INT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### date ``` date(STRING, STRING{0..*}) -> STRING? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### datetime ``` datetime(STRING, STRING{0..*}) -> STRING? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### glob ``` glob(STRING^, STRING^) -> BOOL ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### group\_concat ``` group_concat(STRING^, STRING{0..1}) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### hex ``` hex(BINARY) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### ifnull ``` ifnull(a?, a^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### impure ``` impure(a^) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | yes | no | ### instr ``` instr( a^, a^) -> INT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### julianday ``` julianday(STRING, STRING{0..*}) -> STRING? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### last\_insert\_rowid ``` last_insert_rowid() -> INT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### length ``` length(^) -> INT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### like ``` like(STRING^, STRING^, STRING^{0..1}) -> BOOL ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### likelihood ``` likelihood(BOOL, FLOAT64) -> BOOL ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### likely ``` likely(BOOL) -> BOOL ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### lower ``` lower(STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### ltrim ``` ltrim(STRING^, STRING^{0..1}) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### max ``` max(a^, a^{0..*}) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### min ``` min(a^, a^{0..*}) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### nullable ``` nullable(a?) -> a? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | yes | no | ### nullif ``` nullif(a, a) -> a? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### printf ``` printf(STRING^, {0..*}) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### quote ``` quote() -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### random ``` random() -> INT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### randomblob ``` randomblob() -> BINARY ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### replace ``` replace(STRING^, STRING^, STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### round ``` round(FLOAT64^, ^{0..1}) -> FLOAT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### rtrim ``` rtrim(STRING^, STRING^{0..1}) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### soundex ``` soundex(STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### sqlite\_compileoption\_get ``` sqlite_compileoption_get() -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### sqlite\_compileoption\_used ``` sqlite_compileoption_used(STRING^) -> BOOL ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### sqlite\_source\_id ``` sqlite_source_id() -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### sqlite\_version ``` sqlite_version() -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### strftime ``` strftime(STRING, STRING, STRING{0..*}) -> STRING? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### substr ``` substr(STRING^, ^, ^{0..1}) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### sum ``` sum( a) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### time ``` time(STRING, STRING{0..*}) -> STRING? ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### total ``` total( a) -> a ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | yes | ### total\_changes ``` total_changes() -> INT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | no | no | no | ### trim ``` trim(STRING^, ^{0..1}) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### typeof ``` typeof() -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### unicode ``` unicode(STRING^) -> INT64 ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### unlikely ``` unlikely(BOOL) -> BOOL ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### unsafe\_coerce ``` unsafe_coerce(^) -> ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | yes | no | ### upper ``` upper(STRING^) -> STRING ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | ### zeroblob ``` zeroblob() -> BINARY ``` | Idempotent | Erased | Aggregate | | ---------- | ------ | --------- | | yes | no | no | *** [← Functions](/rezoom-sql/language/functions.md) | [TSQL →](/rezoom-sql/language/functions/tsqlfunctions.md) --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://humbobst.gitbook.io/rezoom-sql/language/functions/sqlitefunctions.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.