Concat

a || b 

Lower / Upper

• For Ascii characters

lower(colA)
upper(colB)

• For unicode character, you must have the International ICU extension loaded

Does not work on Java

Camel Case

substr(textColumnName,1,1) || lower(substr(textColumnName,2))

Printf

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