sqlime
Available SQL Functions
Sqlime offers both standard SQLite functions and many more from the Sqlean project:
general-purpose
date and time
math
aggregate
window
encode/decode
dynamic SQL
fuzzy matching
IP addresses
regular expressions
statistics
text
UUIDs
General-purpose functions
abs
changes
char
coalesce
format
glob
hex
ifnull
iif
instr
last_insert_rowid
length
like
lower
ltrim
max
min
nullif
quote
random
randomblob
replace
round
rtrim
sign
soundex
sqlite_version
substring
total_changes
trim
typeof
unhex
unicode
upper
zeroblob
Date and time functions
date
time
datetime
julianday
unixepoch
strftime
Math functions
acos
acosh
asin
asinh
atan
atan2
atanh
ceil
cos
cosh
degrees
exp
floor
ln
log
log10
log2
mod
pi
pow
radians
sin
sinh
sqrt
tan
tanh
trunc
Aggregate functions
avg
count
group_concat
max
min
sum
total
Window functions
avg
count
cume_dist
dense_rank
first_value
group_concat
lag
last_value
lead
max
min
nth_value
ntile
percent_rank
rank
row_number
sum
total
Encode/decode/digest functions
decode
encode
crypto_blake3
crypto_md5
crypto_sha1
crypto_sha256
crypto_sha384
crypto_sha512
Dynamic SQL
Fuzzy string matching
fuzzy_caver
fuzzy_damlev
fuzzy_editdist
fuzzy_hamming
fuzzy_jarowin
fuzzy_leven
fuzzy_osadist
fuzzy_phonetic
fuzzy_rsoundex
fuzzy_soundex
fuzzy_translit
IP address manipulation
ipcontains
ipfamilyip
iphost
ipmasklen
ipnetwork
Regular expressions
regexp_capture
regexp_like
regexp_replace
regexp_substr
regexp
Mathematical Statistics
stats_median
stats_p25
stats_p75
stats_p90
stats_p95
stats_p99
stats_perc
stats_stddev_pop
stats_stddev
stats_var_pop
stats_var
stats_seq
Text functions
text_bitsize
text_concat
text_contains
text_count
text_has_prefix
text_has_suffix
text_index
text_join
text_last_index
text_left
text_length
text_like
text_lower
text_lpad
text_ltrim
text_repeat
text_replace
text_reverse
text_right
text_rpad
text_rtrim
text_size
text_slice
text_split
text_substring
text_title
text_translate
text_trim
text_upper