Built in functions

Here you can find tables with functions in SQLite and their sqlite_orm availability status.

• master ✅ means that function is available in master branch
• dev ⚠️ means that function is available in dev branch
• none ⛔️ means that function is not available in either branch

Aggregate functions

Name	Availability
avg	master ✅
count	master ✅
max	master ✅
min	master ✅
sum	master ✅
group_concat	master ✅

Core functions

Name	Availability
abs	master ✅
changes	master ✅
char	master ✅
coalesce	master ✅
glob	master ✅
hex	master ✅
ifnull	dev ⚠️
iif	none ⛔️
instr	master ✅
last_insert_rowid	dev ⚠️
length	master ✅
like	master ✅
likelihood	none ⛔️
likely	none ⛔️
load_extension	none ⛔️
lower	master ✅
ltrim	master ✅
max	master ✅
min	master ✅
nullif	none ⛔️
printf	none ⛔️
quote	master ✅
random	master ✅
randomblob	master ✅
replace	master ✅
round	master ✅
rtrim	master ✅
sign	none ⛔️
soundex	master ✅
sqlite_compileoption_get	none ⛔️
sqlite_compileoption_used	none ⛔️
sqlite_offset	none ⛔️
sqlite_source_id	none ⛔️
sqlite_version	none ⛔️
substr	master ✅
substring	none ⛔️
total_changes	dev ⚠️
trim	master ✅
typeof	dev ⚠️
unicode	dev ⚠️
unlikely	none ⛔️
upper	master ✅
zeroblob	master ✅

Date and time functions

Name	Availability
date	master ✅
time	master ✅
datetime	master ✅
julianday	master ✅
strftime	master ✅

Math functions

Name	Availability
acos	dev ⚠️
acosh	dev ⚠️
asin	dev ⚠️
asinh	dev ⚠️
atan	dev ⚠️
atan2	dev ⚠️
atanh	dev ⚠️
ceil	dev ⚠️
ceiling	dev ⚠️
cos	dev ⚠️
cosh	dev ⚠️
degrees	dev ⚠️
exp	dev ⚠️
floor	dev ⚠️
ln	dev ⚠️
log	dev ⚠️
log10	dev ⚠️
log	dev ⚠️
log2	dev ⚠️
mod	dev ⚠️
pi	dev ⚠️
pow	dev ⚠️
power	dev ⚠️
radians	dev ⚠️
sin	dev ⚠️
sinh	dev ⚠️
sqrt	dev ⚠️
tan	dev ⚠️
tanh	dev ⚠️
trunc	dev ⚠️

External links

• Aggregate functions in SQLite
• Core functions in SQLite
• Date and time functions in SQLite
• Math functions in SQLite