neuralib.sqlp.func

SQL functions.

covers * https://www.sqlite.org/lang_corefunc.html * https://www.sqlite.org/lang_aggfunc.html * https://www.sqlite.org/lang_mathfunc.html

neuralib.sqlp.func.abs(x)

https://www.sqlite.org/lang_corefunc.html#abs

Parameters:

x (N)

Return type:

N

neuralib.sqlp.func.changes()

https://www.sqlite.org/lang_corefunc.html#changes

Return type:

int

neuralib.sqlp.func.char(*x)

https://www.sqlite.org/lang_corefunc.html#char

Return type:

str

neuralib.sqlp.func.coalesce(*x)

https://www.sqlite.org/lang_corefunc.html#coalesce

Parameters:

x (T)

Return type:

T | None

neuralib.sqlp.func.format(fmt, *x)

https://www.sqlite.org/lang_corefunc.html#format

Parameters:

fmt (LiteralString)

Return type:

str

neuralib.sqlp.func.hex(x)

https://www.sqlite.org/lang_corefunc.html#hex

Parameters:

x (bytes)

Return type:

str

neuralib.sqlp.func.ifnull(x, y)

x?:y

https://www.sqlite.org/lang_corefunc.html#ifnull

Parameters:

• x (T)

• y (T)

Return type:

T

neuralib.sqlp.func.iif(x, y, z)

x?y:z

https://www.sqlite.org/lang_corefunc.html#iif

Parameters:

• y (T)

• z (T)

Return type:

T

neuralib.sqlp.func.instr(x, y)

x.find(y)

https://www.sqlite.org/lang_corefunc.html#instr

Parameters:

• x (str)

• y (str)

Return type:

int

neuralib.sqlp.func.last_insert_rowid()

https://www.sqlite.org/lang_corefunc.html#last_insert_rowid

Return type:

int

neuralib.sqlp.func.length(x)

https://www.sqlite.org/lang_corefunc.html#length

Parameters:

x (str | bytes)

Return type:

int

neuralib.sqlp.func.likelihood(x, y)

https://www.sqlite.org/lang_corefunc.html#likelihood

Parameters:

• x (T)

• y (float)

Return type:

T

neuralib.sqlp.func.likely(x)

https://www.sqlite.org/lang_corefunc.html#likely

Parameters:

x (T)

Return type:

T

neuralib.sqlp.func.lower(x)

https://www.sqlite.org/lang_corefunc.html#lower

Parameters:

x (str)

Return type:

str

neuralib.sqlp.func.ltrim(x, y=None)

https://www.sqlite.org/lang_corefunc.html#ltrim

Parameters:

• x (str)

• y (str)

Return type:

str

neuralib.sqlp.func.max(x: N) → N

neuralib.sqlp.func.max(x: N, *other: N) → N

https://www.sqlite.org/lang_corefunc.html#max https://www.sqlite.org/lang_aggfunc.html#max_agg

neuralib.sqlp.func.min(x: N) → N

neuralib.sqlp.func.min(x: N, *other: N) → N

https://www.sqlite.org/lang_corefunc.html#min https://www.sqlite.org/lang_aggfunc.html#min_agg

neuralib.sqlp.func.nullif(x, y)

x if x != y else None

https://www.sqlite.org/lang_corefunc.html#nullif

Parameters:

• x (T)

• y (T)

Return type:

T | None

neuralib.sqlp.func.octet_length(x)

https://www.sqlite.org/lang_corefunc.html#octet_length

Parameters:

x (str)

Return type:

int

neuralib.sqlp.func.printf(fmt, *x)

https://www.sqlite.org/lang_corefunc.html#printf

Parameters:

fmt (LiteralString)

Return type:

str

neuralib.sqlp.func.quote(x)

https://www.sqlite.org/lang_corefunc.html#quote

Parameters:

x (str)

Return type:

SqlExpr

neuralib.sqlp.func.random()

https://www.sqlite.org/lang_corefunc.html#random

Return type:

int

neuralib.sqlp.func.randomblob(n)

https://www.sqlite.org/lang_corefunc.html#randomblob

Parameters:

n (int)

Return type:

bytes

neuralib.sqlp.func.replace(x, y, z)

https://www.sqlite.org/lang_corefunc.html#replace

Parameters:

• x (str)

• y (str)

• z (str)

Return type:

str

neuralib.sqlp.func.round(x, y=None)

https://www.sqlite.org/lang_corefunc.html#round

Parameters:

• x (float)

• y (int)

Return type:

float

neuralib.sqlp.func.rtrim(x, y=None)

https://www.sqlite.org/lang_corefunc.html#rtrim

Parameters:

• x (str)

• y (str)

Return type:

str

neuralib.sqlp.func.sign(x: N) → int

neuralib.sqlp.func.sign(x: Any) → None

https://www.sqlite.org/lang_corefunc.html#sign

neuralib.sqlp.func.sqlite_source_id()

https://www.sqlite.org/lang_corefunc.html#sqlite_source_id

Return type:

str

neuralib.sqlp.func.sqlite_version()

https://www.sqlite.org/lang_corefunc.html#sqlite_version

Return type:

str

neuralib.sqlp.func.substr(x, y, z=None)

https://www.sqlite.org/lang_corefunc.html#substr

Parameters:

• x (str)

• y (int)

• z (int)

Return type:

str

neuralib.sqlp.func.total_changes()

https://www.sqlite.org/lang_corefunc.html#total_changes

Return type:

int

neuralib.sqlp.func.trim(x, y=None)

https://www.sqlite.org/lang_corefunc.html#trim

Parameters:

• x (str)

• y (str)

Return type:

str

neuralib.sqlp.func.typeof(x)

https://www.sqlite.org/lang_corefunc.html#typeof

Return type:

str

neuralib.sqlp.func.unhex(x, y=None)

https://www.sqlite.org/lang_corefunc.html#unhex

Parameters:

x (str)

Return type:

bytes

neuralib.sqlp.func.unicode(x)

https://www.sqlite.org/lang_corefunc.html#unicode

Parameters:

x (str)

Return type:

int

neuralib.sqlp.func.unlikely(x)

https://www.sqlite.org/lang_corefunc.html#unlikely

Parameters:

x (T)

Return type:

T

neuralib.sqlp.func.upper(x)

https://www.sqlite.org/lang_corefunc.html#upper

Parameters:

x (str)

Return type:

str

neuralib.sqlp.func.zeroblob(n)

https://www.sqlite.org/lang_corefunc.html#zeroblob

Parameters:

n (int)

Return type:

bytes

neuralib.sqlp.func.avg(x)

https://www.sqlite.org/lang_aggfunc.html#avg

Return type:

float

neuralib.sqlp.func.count(x=None)

https://www.sqlite.org/lang_aggfunc.html#count

Return type:

int

neuralib.sqlp.func.group_concat(x, y=None)

https://www.sqlite.org/lang_aggfunc.html#group_concat

Return type:

str

neuralib.sqlp.func.sum(x)

https://www.sqlite.org/lang_aggfunc.html#sumunc

Return type:

float

neuralib.sqlp.func.acos(x)

https://www.sqlite.org/lang_mathfunc.html#acos

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.acosh(x)

https://www.sqlite.org/lang_mathfunc.html#acosh

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.asin(x)

https://www.sqlite.org/lang_mathfunc.html#asin

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.asinh(x)

https://www.sqlite.org/lang_mathfunc.html#asinh

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.atan(x)

https://www.sqlite.org/lang_mathfunc.html#atan

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.atan2(y, x)

https://www.sqlite.org/lang_mathfunc.html#atan2

Parameters:

• y (float)

• x (float)

Return type:

float

neuralib.sqlp.func.atanh(x)

https://www.sqlite.org/lang_mathfunc.html#atanh

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.ceil(x)

https://www.sqlite.org/lang_mathfunc.html#ceil

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.cos(x)

https://www.sqlite.org/lang_mathfunc.html#cos

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.cosh(x)

https://www.sqlite.org/lang_mathfunc.html#cosh

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.degrees(x)

https://www.sqlite.org/lang_mathfunc.html#degrees

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.exp(x)

https://www.sqlite.org/lang_mathfunc.html#exp

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.floor(x)

https://www.sqlite.org/lang_mathfunc.html#floor

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.ln(x)

https://www.sqlite.org/lang_mathfunc.html#ln

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.log(b, x)

https://www.sqlite.org/lang_mathfunc.html#log

Parameters:

• b (float)

• x (float)

Return type:

float

neuralib.sqlp.func.log2(x)

https://www.sqlite.org/lang_mathfunc.html#log2

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.log10(x)

https://www.sqlite.org/lang_mathfunc.html#log

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.mod(x, y)

https://www.sqlite.org/lang_mathfunc.html#mod

Parameters:

• x (float)

• y (float)

Return type:

float

neuralib.sqlp.func.pi()

https://www.sqlite.org/lang_mathfunc.html#pi

Return type:

float

neuralib.sqlp.func.pow(x, y)

https://www.sqlite.org/lang_mathfunc.html#pow

Parameters:

• x (float)

• y (float)

Return type:

float

neuralib.sqlp.func.radians(x)

https://www.sqlite.org/lang_mathfunc.html#radians

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.sin(x)

https://www.sqlite.org/lang_mathfunc.html#sin

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.sinh(x)

https://www.sqlite.org/lang_mathfunc.html#sinh

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.sqrt(x)

https://www.sqlite.org/lang_mathfunc.html#sqrt

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.tan(x)

https://www.sqlite.org/lang_mathfunc.html#tan

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.tanh(x)

https://www.sqlite.org/lang_mathfunc.html#tanh

Parameters:

x (float)

Return type:

float

neuralib.sqlp.func.trunc(x)

https://www.sqlite.org/lang_mathfunc.html#trunc

Parameters:

x (float)

Return type:

float