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 functions
decode
encode
md5
sha1
sha256
sha384
sha512
Dynamic SQL
Fuzzy string matching
caverphone
phonetic_hash
rsoundex
soundex
dlevenshtein
edit_distance
hamming
jaro_winkler
levenshtein
osa_distance
translit
IP address manipulation
ipcontains
ipfamilyip
iphost
ipmasklen
ipnetwork
Regular expressions
regexp_capture
regexp_like
regexp_replace
regexp_substr
regexp
Mathematical Statistics
generate_series
median
percentile_25
percentile_75
percentile_90
percentile_95
percentile_99
percentile
stddev_pop
stddev
var_pop
variance
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_lpad
text_ltrim
text_repeat
text_replace
text_reverse
text_right
text_rpad
text_rtrim
text_size
text_slice
text_split
text_substring
text_translate
text_trim